INFO: Registry Entries and Keywords for SQL Server Connection Strings

When you create a system DSN in the ODBC Data Source Administrator in Control Panel, and you use the Microsoft SQL Server ODBC driver, the DSN settings are saved in a registry key under the following with the same name of your DSN: < B>HKEY_LOCAL_MACHINESoftwareODBCOdbc.ini</B> If you create a user DSN, the settings are saved in a registry key under the following: < B>HKEY_CURRENT_USERSoftwareODBCOdbc.ini</B> <BR/><BR/> The Microsoft SQL Server ODBC Driver setup also writes parameters to the Odbc.ini registry entry. There are several parameters in the Microsoft SQL Server ODBC Driver setup that have a default value. When you first […]

Read more