ODBC connection using Oracle 10g R2 Client to Oracle 10g R2 database
699522Oct 29 2009 — edited Nov 17 2009Hello,
We have been using Oracle 10g R2 database and wanted to connect to the database using JDBC-ODBC bridge through Oracle 10g R2 Client.
After creating the DSN in the ODBC Datasources in Windows 2003, we were able to Test the connection successfully.
But, the problem comes when we keep the timeout on the statement for the queries which we execute. It throws Driver not capable
We were able to find this being documented on the Microsoft support site:
http://support.microsoft.com/kb/251248
The next alternative we tried was to use the oracle Instant Client and followed the instructions given in this link:
http://www.oracle.com/technology/tech/oci/instantclient/releasenotes/ODBC_IC_ReleaseNotes.html
In the above link, it has been suggested that the DLLs - oci.dll, oraociei10.dll, orannzsbb10.dll be kept in the directory where the instant client
package is inflated. But, the DLL oraociei10.dll is not packaged along with the Oracle 10g Client.
My questions are :
1. How do we get the Oracle 10g R2 client itself working for setting/reading the timeout on the statement on windows 2003.
Statement.getQueryTimeOut and Statement,setQueryTimeOut should work appropriately.
2. The link from Oracle site where the oraociei10.dll can be downloaded and used alongwith the Oracle instant client.
OR the Oracle client version which packages this DLL. Looking for an authenticated site for downloading this DLL.
Thanks in advance for your suggestions.
Best Regards,
Naveen