Question on settings ODBC values via VB

[Michael Kizer]

I have created a new DSN for a SQL Server db via VB and an API call to ODBCCP32.DLL, which all seems to work fine (thanks to members of this forum).

The only problem I have is when the application runs for the first time on a new machine (configured with ODBC, but with no DSNs), the setting for "Network Library" under "Client Configuration" defaults to "Named Pipes". My application requires a TCP/IP connection to the db.

Is there any way to programatically set this value?

[Michael Kizer]

Interesting... That setting must be stored outside of the ODBC settings. If I delete the DSN (now there are none on the machine), and run the app again to let it create one, it works fine (uses TCP/IP as the default instead of Named Pipes)...