11/4/2019 Oracle 7.3 Client Software Installation
The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of Oracle version 7.3 (or greater) client software installation Setting up a User DSN not as adminstrator using Oracle instant client driver. Error: 12170: TNS: Connection timeout occurred. Oracle(tm) client and networking components were not found ple help me in this regard. I am also trying to download odbc driver from oracle site and dont know where the files are need to be place in BI home. I have win XP Professional pls BI enterprise edition 10.1.3 Regard's.
This is particularly problematic when permissions set on plist entries or files prevent the successful installation of new installs and/or updates. The Adobe Reader and Acrobat Cleaner Tool is designed to fix such issues by cleaning up corrupted installations, including removing or fixing corrupted files, removing or changing permissions registry entries, etc.
Active3 years, 1 month ago
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:
Oracle 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.
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?
Burgi
4,5701010 gold badges2929 silver badges4545 bronze badges
MalvineousMalvineous
Oracle Client 7.3
1,69122 gold badges1414 silver badges2929 bronze badges
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:
4,2781111 gold badges1919 silver badges3333 bronze badges
Oracle Version 7.3 Or Greater Client Software Installation
AutoDevAutoDev
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 MalvineousMalvineous
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.
1,69122 gold badges1414 silver badges2929 bronze badges
Not the answer you're looking for? Browse other questions tagged windows-7databaseodbc or ask your own question.
Active1 year ago
I'm trying to connect to an Oracle DB through Excel. I have installed the Instant Client from Oracle on my machine, but am getting this message when I run this code:
The message I am getting is
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
Furthermore, installing the wrong Canon drivers can make these problems even worse.Recommendation: If you are inexperienced with updating Canon device drivers manually, we highly recommend downloading the. Canoscan lide 30 driver. This tool will download and update the correct Canon CanoScan LiDE 30 driver versions automatically, protecting you against installing the wrong CanoScan LiDE 30 drivers. Using outdated or corrupt Canon CanoScan LiDE 30 drivers can cause system errors, crashes, and cause your computer or hardware to fail. Maintaining updated Canon CanoScan LiDE 30 software prevents crashes and maximizes hardware and system performance. Manufacturer:CanonHardware Type:ScannerModel:CanoScanSeries:LiDE 30Compatibility:Windows XP, Vista, 7, 8, 10Downloads:85,090,059Download Size:3.4 MBDatabase Update:Available Using DriverDoc:Optional Offer for DriverDoc by Solvusoft This page contains information about installing the latest Canon CanoScan LiDE 30 driver downloads using the.Canon CanoScan LiDE 30 drivers are tiny programs that enable your Scanner hardware to communicate with your operating system software.
Leniel Maccaferri
84k3636 gold badges303303 silver badges410410 bronze badges
jDave1984jDave1984
40311 gold badge66 silver badges2323 bronze badges
2 Answers
I see this error frequently when our desktop support team installs the wrong Oracle client. If your application (Excel, in this case) is 32-bit, then you also need to be using 32-bit ODBC and 32-bit Oracle client. It doesn't matter that your OS or hardware is 64-bit. What matters is the application. And it seems that most MS Office installations are 32-bit, even when installed on 64-bit Windows.
EdStevensEdStevens
In my case, the Console project in Visual Studio had
Prefer 32 bit check-marked in its Properties.
Press Alt + Enter and open the Build section.
I unchecked it and then the app worked perfectly.
By the way: I had installed Oracle client 64 bit.
Leniel MaccaferriLeniel Maccaferri
84k3636 gold badges303303 silver badges410410 bronze badges
Not the answer you're looking for? Browse other questions tagged excelvbaoracleoracleclient or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |