Caché ODBC FAQ

By default, Caché performs a full ODBC installation with a standard installation.   However, InterSystems also provides a simple stand-alone installer for Caché ODBC.  Here is a list of Frequently Asked Questions concerning the stand-alone drivers.

Q: Where can I find the ODBC stand-alone drivers for Caché?
A: These can be found on our ftp server at: ftp://ftp.intersystems.com/pub/cache/odbc

Q: Do I need a username and password access to download the driver?
A: No.  These are accessible in the public area of our ftp server at: ftp://ftp.intersystems.com/pub/cache/odbc
For username, enter anonymous and for password, enter your valid email address.

Q: When I install, there are two drivers (CacheODBC and CacheODBC35).  What does this mean?
A: 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

Q: My client application is 32-bit but the Operating System is 64-bit.  What ODBC driver should I use?
A: 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.

Q: I am running an older version of Caché (5.0.11).  Can I use the latest driver?
A: 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.

Q: My server is running Caché 2010.2.6.  Can I use the latest driver?
A: Yes.  Generally ODBC clients are backwards compatible.  However, if you are using the ODBC Client against an application from a Reseller, please check with them first to discover on what client versions they have tested and approve for their application.