I am trying to use TestODBCConnection to determine whether database login credentials entered by a user are valid.
Following the guide at http://www.advancedinstaller.com/user-g ... ction.html I am attempting to connect to an Oracle server. However, the machine I am deploying on does not have a valid ODBC driver installed for "Microsoft ODBC for Oracle". I do have however Orcale 11g instantclient (64 bit version) already installed on the machine. It seems desirable to use an Oracle made driver anyway since the use of "Microsoft ODBC for Oracle" (msorcl32) is not supported anymore and it is recommended to use an Oracle made ODBC driver.
When I try to use the Oracle driver in my connection string however, it does not seem to find it when using TestODBCConnection. The Connection string I use is:
Driver=[\{]Oracle in instantclient_11_2[\}];Server=......
I see Oracle in instantclient_11_2 in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
However, TestODBCConnection only seems to find the drivers located in the 32 bit registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI
Is there a way to have the 64 bit drivers recognized by TestODBCConnection?