Can MS ODBC driver work properly with Oracle 10g database?
613599Dec 18 2007 — edited Jan 15 2008Does any body know or found any issue/problem when use Microsoft ODBC driver to connect with Oracle 10g database?
Previously, our application used ODBC driver provided by Oracle Client (Oracle Client 10g R2) connecting to remote Oracle DB 10g. We found that our application, running on Win 2003, had caused CPU rising to 100%. With or without Oracle driver patch 10.2.0.3, the CPU are still up to 100%.
Now we have changed our application to use MS ODBC driver connecting to Oracle 10g database with the same work load. The result turned to be that our application uses only 25% CPU.
We are going to use MS ODBC driver (version 2.576.1830.00) provided with Win 2003 to connect to DB.
We would like to know if anybody found any issues from using MS ODBC driver to connect to Oracle 10g database? Is there any solution for our CPU consumption problem?
Thank you very much.