Hi, thanks for that reference, I cannot see the Oracle 11g ODBC drivers from here. I have looked at this page before.
I can see the Oracle Database 11g Release 1 (220.127.116.11) JDBC drivers this found when scrolling down the page to the Driver section and selecting JDBC, when selecting ODBC you are directed to a page showing Oracle ODBC Driver and selecting Software from the Oracle ODBC resources takes you to a page with Oracle 10, Oracle 9 ODBC drivers,
I cannot see Oracle 11g ODBC drivers for Windows anywhere.
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
instantclient-basic-win32-18.104.22.168.0.zip (43,316,697 bytes)
*Instant Client Package - Basic Lite: Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only)
instantclient-basiclite-win32-22.214.171.124.0.zip (17,012,357 bytes)
*Instant Client Package - JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC
instantclient-jdbc-win32-126.96.36.199.0.zip (1,560,750 bytes)
Instant Client Package - SQLPlus: Additional libraries and executable for running SQL*Plus with Instant Client instantclient-sqlplus-win32-188.8.131.52.0.zip (788,050 bytes)
*Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client instantclient-sdk-win32-184.108.40.206.0.zip (1,059,905 bytes)
It sounds like *Instant Client Package - ODBC: Additional libraries for enabling ODBC applications instantclient-odbc-win32-220.127.116.11.0.zip (725,154 bytes) is only the ODBC drivers (which is what I want), i do not want to install Oracle Client as I already have Oracle 11g DB install. I am testing windows ODBC applications with Oracle11g, hence the need for the Oracle11g ODBC drivers.
thanks for your help. I will give these drivers a try.
After installing "ODTwithODAC1110621.zip" (using the setup.exe inside, of course), ODBC had error code 126.
Resolved by copying file mfc71.dll to client_1 directory.
It seems this DLL is still missing in installation package.