I used to use below registry to import some settings for setting up odbc on Windows Server 2003 32-bit. Now I want to do the same on a Windows Server 2003 64-bit for 32-bit odbc driver not the 64-bit one. Is there any way to modify the registry? Since this one will create entries for 64-bit odbc driver.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MY_DB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="10.1.1.1"
"Database"="MY_DB"
"LastUser"="db_account"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"MY_DB"="SQL Server"
Best Answer
If you want to configure 32 bit ODBC on 64 bit Windows then use:
ODBC setting visible to 32 bit applications will be stored here. If you create 32 bit installer then use simply
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
and Windows will map it toWow6432Node
. More info about mapping registry to 32 bit apps on Win64 can be found here: http://support.microsoft.com/kb/305097