Which ODBC driver to choose for a multi version , multi home installation
581547Jun 6 2007 — edited Jun 13 2007I have a situation where I need to rollout a piece of software which connects to an Oracle 64 bit database. The client group that I need to rollout to includes a combination of Oracle8, Oracle 9 and Oracle 10. Some installations have dual 8/9 Homes and I am sure that there are other combinations.
The software connects through either a normal oracle connection or can connect through ODBC. However, the normal connection software will not connect through Oracle below Oracle 9, So I am left with an ODBC driver. I am using the microsoft driver currently - it is very slow, but it is at least already installed on all the user pc's. However I believe that it does not work with dual homes.
Is there an Oracle driver that would meet our needs?, i.e allow connections from version 8 to 10 with any combination of homes.