Oracle Client Odbc Driver
- Download the Oracle Instant Client and ODBC Driver. This can be done from the Oracle site using the following links. You will need to have a signon to Oracle in order to do this.
- Jan 09, 2019 Hello everyone, welcome to my blog. In this article, I am going to show you how to install Oracle ODBC Driver on Windows 10. I have a working Oracle Database 12c on another computer on my home network. I am trying to connect to my Oracle database.
- Hello everyone, welcome to my blog. In this article, I am going to show you how to install Oracle ODBC Driver on Windows 10. I have a working Oracle Database 12c on another computer on my home network. I am trying to connect to my Oracle database from Microsoft Access using ODBC connection.
- Install Oracle Client Odbc Driver
- Oracle Client Odbc Drivers 64 Bit
- Oracle Instant Client Odbc Driver
- Oracle 10g Client Odbc Driver Download
- Oracle 11g Client Odbc Driver 32 Bit
- Oracle 10g Client Odbc Driver Install
Progress DataDirect’s ODBC Driver for Oracle Database Cloud Service offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Oracle Database Cloud Service data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX.
I have an old 32-bit software program that connects to an Oracle database but only works with the Microsoft ODBC driver for Oracle. It does not work with the more up-to-date native Oracle ODBC driver.
I have installed the Oracle Instant Client (32-bit and 64-bit versions on my 64-bit Win 7 PC), each into different ORACLE_HOME directories.
However when I try to connect via ODBC with Microsoft's driver, I get the error:
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.
You will be unable to use this driver until these components have been installed.
I can connect to the database fine with Oracle's ODBC driver so the install seems fine, but alas this program will only work with Microsoft's ODBC driver.
Since the Microsoft ODBC driver is apparently unable to find the Oracle Instant Client install, how should I tell it where to look?
Burgi2 Answers
Technology used: Windows 7, UFT 32 bit, Data Source ODBC pointing out to 32 bit C:WindowsSystem32odbcad32.exe, Oracle client with both versions installed 32 bit and 64 bit.
What worked for me:
- Start -> search for “Edit the system environment variables”
- System Variables -> Edit Path
Place the path for Oracle client 32 bit in front of the path for Oracle Client 64 bit. Ex:
Install Oracle Client Odbc Driver
Turns out this is quite simple. You have to set the PATH environment variable to point to the ORACLE_HOME that you want to use.
For me, I edited the PATH to add ;C:oracleinstantclient32_12_1 on the end and it worked perfectly, no restart needed.
For clarification, the C:oracleinstantclient32_12_1 directory I specified contains files like oci.dll and ociw32.dll and belonged to the 32-bit Instant Client install. I guess it doesn't matter for 64-bit, since there is no Microsoft ODBC 64-bit client.
Not the answer you're looking for? Browse other questions tagged windows-7databaseodbc or ask your own question.
Version 19.3.0.0.0
Base - one of these packages is required
Name | Download | Description |
|---|---|---|
| Basic Package | All files required to run OCI, OCCI, and JDBC-OCI applications (77,461,111 bytes) (cksum - 1229146321) The 19.3 Basic package requires the Microsoft Visual Studio 2017 Redistributable. | |
| Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (37,200,187 bytes) (cksum - 3231965870) The 19.3 Basic package requires the Microsoft Visual Studio 2017 Redistributable. |
Tools - optional packages
Name | Download | Description |
|---|---|---|
| SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (885,778 bytes) (cksum - 1517454610) | |
| Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (973,602 bytes) (cksum - 3020355187) |
Development and Runtime - optional packages
Name | Download | Description |
|---|---|---|
| SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,502,057 bytes) (cksum - 1500410010) | |
| JDBC Supplement Package | Additional support for Internationalization under JDBC (1,583,298 bytes) (cksum - 82258153) | |
| ODBC Package | Additional libraries for enabling ODBC applications (795,048 bytes) (cksum - 3848514660) | |
| Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 18.5.0.0.0
Base - one of these packages is required
Name | Download | Description |
|---|---|---|
| Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (74,140,828 bytes) (cksum - 297900794) | |
| Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (35,549,981 bytes) (cksum - 1491364376) |
Tools - optional packages
Name | Download | Description |
|---|---|---|
| SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (884,077 bytes) (cksum - 3590737221) | |
| Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (950,904 bytes) (cksum - 3310954301) |
Development and Runtime - optional packages
Name | Download | Description |
|---|---|---|
| SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,502,950 bytes) (cksum - 330016902) | |
| JDBC Supplement Package | Additional support for Internationalization under JDBC (1,580,553 bytes) (cksum - 4009011077) | |
| ODBC Package | Additional libraries for enabling ODBC applications (748,991 bytes) (cksum - 2563637832) | |
| Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.2.0.1.0
Base - one of these packages is required
Name | Download | Description |
|---|---|---|
| Basic Package | All files required to run OCI, OCCI, and JDBC:OCI applications (71,881,824 bytes) (cksum - 3943816961) The 12.2 Basic package requires the Microsoft Visual Studio 2013 Redistributable. | |
| Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (33,952,164 bytes) (cksum - 3100478757) The 12.2 Basic Light package requires the Microsoft Visual Studio 2013 Redistributable. |
Tools - optional packages
Name | Download | Description |
|---|---|---|
| SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (869,596 bytes) (cksum - 3936688114) | |
| Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (953,250 bytes) (cksum - 3613837252) |
Development and Runtime - optional packages
Name | Download | Description |
|---|---|---|
| SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,477,702 bytes) (cksum - 4177145789) | |
| JDBC Supplement Package | Additional support for Internationalization under JDBC (1,575,019 bytes) (cksum - 3111443322) | |
| ODBC Package | Additional libraries for enabling ODBC applications - Updated 9/22/2017 (730,779 bytes) (cksum - 2384457566) | |
| Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.1.0.2.0
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (67,410,370 bytes) (cksum - 530881682) The 12.1 Basic package requires the Microsoft Visual Studio 2010 Redistributable. | |
| Instant Client Package - Basic Lite | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (33,851,306 bytes) (cksum - 3971707995) The 12.1 Basic Light package requires the Microsoft Visual Studio 2010 Redistributable. | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,573,642 bytes) (cksum - 2509633653) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (805,513 bytes) (cksum - 2478532846) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,951,770 bytes) (cksum - 722480528) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (505,668 bytes) (cksum - 41700632) | |
| Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (15,225 bytes) (cksum - 2411353204) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Oracle Client Odbc Drivers 64 Bit
Version 11.2.0.4.0
Oracle Instant Client Odbc Driver
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (51,477,933 bytes) | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (20,258,449 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,565,746 bytes) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (757,034 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,114,946 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (740,921 bytes) | |
| Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (12,962 bytes) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.1.0.7.0
Oracle 10g Client Odbc Driver Download
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (46,734,555 bytes) | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (17,667,999 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,562,261 bytes)
| |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (789,617 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (1,068,348 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (728,899 bytes) | |
| Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (6,009 bytes) | |
| Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 10.2.0.5
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (34,846,661 bytes) | |
| Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10,670,287 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,474,417 bytes) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (729,651 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (875,897 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (727,190 bytes) |
Oracle 11g Client Odbc Driver 32 Bit
Version 10.1.0.5
Oracle 10g Client Odbc Driver Install
Name | Download | Description |
|---|---|---|
| Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (31,926,105 bytes) | |
| Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (4,637,410 bytes) | |
| Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (269,139 bytes) | |
| Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (765,019 bytes) | |
| Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (666,571 bytes) |