• Suri,

    You should use Oracle for OracleHome92 as the older version has been desupported, and the older version does have some issues with the newer NLS character sets. There are no specific 9i "features" that depend on the later ODBC driver, but the newer one certainly has rectified bugs. The difference between the MS ODBC and Oracle ODBC drivers has always been this: The Oracle ones understand Oracle specifics such as synonyms, etc, while the MS ODBC drivers are more generic.

    John Kanagaraj