Caché ODBC Driver FAQ
By default, Caché performs a full ODBC installation with a standard installation. InterSystems also provides a simple stand-alone installer for Caché ODBC. Here is a list of Frequently Asked Questions concerning the stand-alone drivers.
You need a user name and password for the WRC Direct application.
If you do not have an account please contact InterSystems support at +1.617.621.0700 or support@InterSystems.com
The ftp server is open to the public.
When you do the install, there are 2 drivers – CacheODBC and CacheODBC35. These support different levels of the ODBC standard. The first support version 2.5 and the second support version 3.5. The ODBC driver Manager will convert 3.5 requests to the older 2.5 automatically, so in most cases you can use either driver.
Use the 32-bit ODBC driver. The ODBC Client Driver’s bit-ness needs to match the bit-ness of the client application that will load it.
No. Generally ODBC clients are backwards compatible. However if you are connecting to a server running Caché 5.0.12 or older then the newest client you can use is Caché 5.2.0.
InterSystems current ODBC client is compatible with any server version greater than 5.0.13. It does not matter if the server is running Caché, Ensemble or HealthShare, any ODBC client will talk to all of them.
InterSystems supports the iODBC driver manager (for use with the Unicode and 8–bit ODBC APIs) and the unixODBC driver manager (for use with the 8–bit ODBC API).
A 64-bit windows machine has 2 driver managers, 1 for 64-bit applications and one for 32-bit applications. You need to use the driver manager that matches your application.
64-bit version: C:\Windows\System32\odbcad32.exe
32-bit version: C:\Windows\SysWOW64\odbcad32.exe