vb6

How to access SQL CE 3.5 from VB6

We have a .NET 3.5 SP1 application written in C# that stores data in an SQL CE 3.5 Database. We also need to access (read only) this very data from a legacy VB6 application. I don't know if this is at all possible. There are several approaches to this problem that I can think of. 1) I have read about ADOCE Connections, but this seems t...

VB6 ADO Connection - How to Check if in Transaction?

Is there any way to tell, using just the ADODB.Connection object, whether or not it is currently involved in a transaction? I'd love to be able to test this on the connect object itself, without relying on keeping a boolean next to it updated. ...

VB6 ActiveX controls into a TCL/Tk application

Whats the most common way of instantiating VB6 ActiveX controls inside of an Tcl/Tk wrapper application. Are there performance issues with this setup i.e. around GDI handles? ...

VB6 Application fails 8.3 path conversion on a single PC

I have a VB6 desktop application that is deployed on well over 1200 desktops. The devices throughout are a mix of Windows XP SP2 and SP3 systems. All but one of these PCs (XP SP2) is able to successfully decipher the DOS 8.3 path (ie C:\PROGRA~1\DATFOL~1\Config\) that is used in an .ini file related to this application. This particular P...

VB6. DataEnvironment: How to Configure/Set Trusted Connection?

Hi, I have a DataEnvironment component in my VB 6 application. I cant configure the DataEnvironment connection to use trusted connection without ask me how to connect. I could set prompt to never appear, but it doesnt connect becouse it doesnt use trusted. In this link you could see the screens of DataEnvironment Connection Options and...

VB6 app printing Crystal Report to Adobe Distiller PDF - how to set PDF filename?

I've got a legacy piece-o'-s- app that I'm maintaining. It's a VB6 app that calls a Crystal Report (Crystal 8 it looks like) and then prints programmatically to the default printer, which is set up as Acrobat Distiller (v5.0). When it prints to PDF, it's automatically placing the resulting PDF in a folder (c:\pdf) and naming it as the ...

VB6 app not executing as scheduled task unless user is logged on

I would greatly appreciate some help on this one! It may be a tricky one. :) Problem I have an VB6 application which is set up as scheduled task. It starts every time, but when executing CreateObject() it fails if a user is not logged on to computer. I am looking for information on what could cause this. My primary suspicion is that s...

Naming convention for VBA modules?

I never really know how to name VBA modules. Should I: Use a prefix, like basName or modName. Not use a prefix, like Module. (But avoid restricted words) Something else ...

How do I pass a struct (or class) message back and forth between a C# service and a separate VB 6 application?

I need to pass data between a c# service and a running vb 6 application, considering using Windows Messaging. How do I pass the data back and forth between a C# service and a running vb 6 application? Shortened sample of the data I am passing back and forth is below: namespace MainSection { public struct Info { private in...

How to keep an old VB6 application running in Windows Vista and Windows 7?

I have an old VB6 app which I'm still trying to support. A few users have reported weird crashes when running the app in Vista or Windows 7. The log files don't show anything after one of these crashes, but the customers report that the error message said "OLE something ...", if they saw anything at all. I've never been able to reprod...

Using C# assemblies from VB6 code. Some issues.

I have a C# assembly, which is regasmed, but is not in the GAC. In my VB6 code, I added a reference to the generated type library (the .tlb file). Then I instantiate the C# lib in my VB6 code. If I run it from the VB6 IDE, it does not work. The Set in the code below: Dim obj as MyCSharpNamespace.MyCSharpObject Set obj = New MyC...

Command$ value disappears

I have a VB6 app. I am trying to figure out what command line parameters got passed into the application. If I type in ? Command$ into the Immediate window, it prints out the command line params fine. Same, if I place Command$ into the Watch window. However, if I assign the Command$ function to a string: Dim s as string s = Comma...

winsock receiving incoming data slower than expected.

Hi folks, I have a sender machine which sends bytearray data to my prog at an interval of about 5 miliseconds/per msg, about 6 - 7 bytearray messages per seconds that is. The problem is that the winsock in my program doesn't seem to receive these bytearray fast enough. For every 10 messages sent over, I am only able to receive about 6 t...

in VB6, why do I have to set version compatibility to No Compatibility from Binary Compatibility, and then back to Binary Compatibility to make things work?

My project was originally set to Binary Compatibility, but it was not building. So I first set it to No Compatibility, it built fine that way. Then I set it back to Binary Compatibility, and overwrote over the previously generated file, it worked fine. Why does this have to happen? ...

Getting XY Coordinates of RichTextBox caret

It's possible to get caret XY coordinates? (Left and Top) ...

How to call a function with function name reference to a string value in VB

I have this algorithm that I want to implement on VB6. Sub Main() dim stringVal1 as string, stringVal2 as string dim getOne as boolean stringVal1 = "FunctOne" stringVal2 = "FunctTwo" if getOne then 'Call Function with function name assigned to stringVal1 ... how to call the function here?** else 'Call Function with function na...

Variable number of arguments in VB

How to create a function with variable number of arguments in visual basic? ex. x = Sum(1,2,3) y = Sum(1,2) Function Sum('how to declare argument here') 'Is there any special argument manipulation inside function before it is usable? End Function ...

Is there added overhead to looking up a column in a DataTable by name rather than by index?

In a DataTable object, is there added overhead to looking up a column value by name thisRow("ColumnA") rather than by the column index thisRow(0)? In which scenarios might this be an issue. I work on a team that has lots of experience writing VB6 code and I noticed that didn't do column lookups by name for DataTable objects or data gri...

How do I access the names of VB6 modules from code?

Hi All - It is unlikely that there is an answer for this one, but I'm asking anyway. I am currently maintaining some code, which is likely to be refactored soon. Before that happens, I want to make the standard error handling code, which is injected by an Add-In, more efficient and take up less space. One thing that annoys me is that...

simple yet secure encrypt / decrypt asp to asp.net

First post here. I have a asp/vb6 web app that logs in a user I want to encrypt the users identity field and pass(querystring) it to a asp.net app and then decrypt it to do a db lookup. I've google'd it of course and found rot13, not secure enough. I've also found some hits on MD5 / RC4 but did not find any good examples of encrypt / ...