This content has been marked as final. Show 2 replies
Yes, you can have multiple versions of Oracle client installed on a single machine (along with the corresponding ODBC driver), and yes you can use more than one version of ODBC at once. You'll need to have the 9i home first in the PATH though, as it doesn't support multiple homes as well as 11g does.
With respect to your ODBC crashes, make sure you're using 11203 client and ODBC. It's pretty stable at this point.
With respect to your poor performance, has your DBA said why? Failure to use index due to wrong bind type for example? There are workarounds in the ODBC driver that were added due to issues discovered as a result of MSAccess. Specifically, you might try the "bind number as float" and "bind timestamp as date" workarounds to see if they help performance. You'll need to relink the tables after changing the DSN options, or just create a new DSN with the option enabled right off the bat, and test with it.
Hope it helps,
I greatly appreciate your reply. On my machine, and on those of my team, we have the 9i and 11g clients installed. The 11g driver is version 11.02.00.01.
Should we be able to access all tables in an Access database where:
- some are 10g tables using 9i drivers and
- some are 11g tables using 11g drivers?
If this should work, what could cause it not to work?