1. Oracle Version 7.3 Client Software Free Download
2. Oracle Version 7.3 Client Software Download
3. Oracle Version 7.3 Client Software Download
4. Oracle Version 7.3 Client Software Installation
5. Oracle 7.3 Client Software Installation
6. Oracle Version 7.3 Or Greater Client Software Installation

Microsoft ODBC driver can't find Oracle Instant Client. Ask Question Asked 4 years, 2 months ago. Active 3 years, 1 month ago. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.

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.

• 'Connection to server failed with Microsoft OLE DB Provider for Oracle. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.'
• Could be a bitness issue, similar to Access 32-bit not being able to work with 64-bit drivers and vice versa.
• These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
• Mar 14, 2017  'Connection to server failed with Microsoft OLE DB Provider for Oracle. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.'

However when I try to connect via ODBC with Microsoft's driver, I get the error:

Oracle Version 7.3 Client Software Free Download

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?

BurgiMalvineousMalvineous

2 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:

1. Start -> search for “Edit the system environment variables”
2. System Variables -> Edit Path

3. Place the path for Oracle client 32 bit in front of the path for Oracle Client 64 bit. Ex:

   Enjoy 🙂Quick tip: If you want to open PowerShell ISE on Windows 8 or Windows Server 2012 machine, it is installed by default, but not visible.The thing is that PowerShell ISE could be found in Administrative tools. Install windows server 2008 r2. Do it:After the host is back online, please login into it, open PowerShell console and run $host in it.You should have listed a version of the Powershell, which I hope, it would be PowerShell 3.0 🙂or in Registry HKLMSoftwareMicrosoftPowerShell:And that is it. It will prompt you do restart OS one more time. Just pin it to a Start panel and you are good to go. You can now use Powershell 3.0 in Windows Server 2008 R2 SP1.

techraf

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.

MalvineousMalvineous

Not the answer you're looking for? Browse other questions tagged windows-7databaseodbc or ask your own question.

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.

Oracle Version 7.3 Client Software Download

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:

Oracle Version 7.3 Client Software Download

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.

Oracle Version 7.3 Client Software Installation

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?

Oracle 7.3 Client Software Installation

BurgiMalvineousMalvineous

2 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:

1. Start -> search for “Edit the system environment variables”
2. System Variables -> Edit Path

3. Place the path for Oracle client 32 bit in front of the path for Oracle Client 64 bit. Ex:

techraf

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.

MalvineousMalvineous

Oracle Version 7.3 Or Greater Client Software Installation

Not the answer you're looking for? Browse other questions tagged windows-7databaseodbc or ask your own question.