Using VB.NET how can I deploy ODBC connection to automatically install when
the package is installed?
YamaConsider 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
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:RWwjZsL1DHA.3564@.cpmsftngxa07.phx.gbl...
quote:
> Consider using a DSN-less connection. Then there is nothing to
distribute.
quote:
> 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.
>
>
