I can easily use the ODBC control panel in Windows to setup an ODBC connection, including the entry of a password followed by the "test connection".. I'm referring to SQL Native Client 10, and SQL Server Authentication mode.
I know how programmatically (VB/C#/C++) add an ODBC entry to the registry, but this doesn't include the password.
Is it possible to write a small program (compiling the password into the code) that will setup the ODBC registry entry and add the password? This is a utility app for some service folks and I want them to be able to configure and verify the ODBC connection without having to inform them of the password.
Can this be done?