How to fix Run-Time error ‘1004’ : General ODBC Error : The Oracle(tm) client and networking components were not found.
Recently I have migrated to windows 7 and one Microsoft excel 2010 form which was working previously stopped working.
and there were two error messages from Microsoft Visual Basic and Microsoft ODBC for Oracle
Microsoft Visual Basic .Run-Time error ‘1004’ : General ODBC Error
Microsoft ODBC for Oracle
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
Though I receive error “The Oracle(tm) client and networking components were not found.” I had oracle 11.2.0 client installed already. Yet excel cant detect my oracle client 11.2.0 . Thus it gives Microsoft ODBC for Oracle error as well as Microsoft Visual Basic error Run-Time error ‘1004’ : General ODBC Error.
Solution for “The Oracle(tm) client and networking components were not found.”
Solution was to add Oracle client path to the system path of windows. Oracle client executables, binaries cannot be identified by windows until it is added to system path variable. My oracle client was located under C:\Oracle\product\11.2.0\client_1 (you once may be different, select it in the way your pc has it)
Go to system properties, —>Advanced—–>Environment Variables—–>path——>Edit.
Then add your oracle client path (C:\Oracle\product\11.2.0\client_1) with a semicolan at the end and click ok
System Path Variable settings for Oracle Client
That’s it
