Hi,

Using VB.NET how can I deploy ODBC connection to automatically install when
the package is installed?

Yama

Consider using a DSN-less connection. Then there is nothing to distribute.

313295 HOW TO: Use the Server Name Parameter in a Connection String to
Specify
http://support.microsoft.com/?id=313295

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Thanks Kevin,

But I had to create the ODBC package for my company legacy program written
in FoxPro!!!

Using InstallShield I was able to distribute the ODBC.

I wrote to the registry the following:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\myDSNName]
"Driver"= %windir% + "\\system32\\SQLSRV32.dll"
"Server"="myServer"
"Database"="myDatabase"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"myDSNName"="SQL Server"

Thank you,

Yama

[quoted text, click to view]