-
Hello. I have a Visual Basic 6.0 SP3 program that utilizes SQL Server 6.5 and ADO connectivity. I have just finished writing and testing my program, and need to know if it's possible to set up an ODBC connection on the fly through Visual Studio's "Package and Development Wizard".
As it stands right now, I need to have every user that installs my program manually configure an ODBC connection to SQL Server through their control panel. Is there any way to automate this?
Any help/suggestions would be great.
Thanks,
Jake
-
I know the answer is yes (because my company does it). However, it was done in C++ and I had nothing to do with it.