I want to know which ODBC driver version is recommended for Oracle 9 and 10.
Is there official Oracle document that says that newest version of Oracle ODBC driver can or even should be used with older servers?
+1
A:
Oracle does not certify ODBC drivers separately (unlike JDBC drivers). Rather they are certified as part of the client. So ODBC driver 9.2.0.x is certified to connect to the same database server versions as client version 9.2.0.x.
Oracle test both ways (old client to new server, new client to old server) but only against the supported versions. In this context what constitutes a supported version varies for server and client.
If you have a Support contract you should check out MOS (formerly Metalink) article on Client/Server Interoperability Support Between Different Oracle Versions (ID 207303.1). But the headline is, if you are using 9.2.0.4 or higher at both ends you're probably safe.
APC
2010-04-23 10:25:53
Michał Niklas
2010-04-23 10:45:03