In addition to copying the ODBC driver files onto disk, your installation program must also make a set of registry entries to install the ODBC driver properly.
The SQL Anywhere installer makes changes to the Windows Registry to identify and configure the ODBC driver. If you are building an installation program for your end users, you should make the same registry settings.
The simplest way to do this is to use the self-registering capability of the ODBC driver. You use the regsvr32 utility on Windows or the regsvrce utility on Windows Mobile. Note that for 64-bit versions of Windows, you can register both the 64-bit and 32-bit versions of the ODBC driver. By using the self-registering feature of the ODBC driver, you are ensured that the proper registry entries are created. To register the 32-bit and 64-bit versions of the ODBC driver, open up a command prompt and issue the following commands.
regsvr32 install-dir\bin32\dbodbc11.dll regsvr32 install-dir\bin64\dbodbc11.dll |
You can use the regedit utility to inspect the registry entries created by the ODBC driver.
The SQL Anywhere ODBC driver is identified to the system by a set of registry values in the following registry key:
HKEY_LOCAL_MACHINE\ SOFTWARE\ ODBC\ ODBCINST.INI\ SQL Anywhere 11 |
Sample values for 32-bit Windows are shown below:
Value name | Value type | Value data |
---|---|---|
Driver | String | install-dir\bin32\dbodbc11.dll |
Setup | String | install-dir\bin32\dbodbc11.dll |
There is also a registry value in the following key:
HKEY_LOCAL_MACHINE\ SOFTWARE\ ODBC\ ODBCINST.INI\ ODBC Drivers |
The value is as follows:
Value name | Value type | Value data |
---|---|---|
SQL Anywhere 11 | String | Installed |
For 64-bit Windows, the 32-bit ODBC driver registry entries ("SQL Anywhere 11" and "ODBC Drivers") will be located under the following key:
HKEY_LOCAL_MACHINE\ SOFTWARE\ Wow6432Node\ ODBC\ ODBCINST.INI |
To view these entries, you must be using a 64-bit version of regedit. If you cannot locate Wow6432Node on 64-bit Windows, then you are using the 32-bit version of regedit.
If you are using a third-party ODBC driver on an operating system other than Windows, consult the documentation for that driver on how to configure the ODBC driver.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |