This content has been marked as final.
Show 7 replies
-
1. Re: Oracle(tm) client and networking components were not found
Jonah H. Harris Oct 5, 2007 1:06 PM (in response to 438932)Looks like you're using the Microsoft ODBC Driver for Oracle, yes? If so, make sure you have an Oracle client installed (full client or instant client) and make sure you have your PATH and ORACLE_HOME environment variables set accordingly. -
2. Re: Oracle(tm) client and networking components were not found
603926 Oct 18, 2007 9:42 AM (in response to 438932)I also have this problem, but in a different way:
I am using 'Actuate 7' (A report writer) to access an ODBC connection to an Oracle DB.
I have created a System DSN and when I connect through Actuate as an 'Admin' user, the connection goes through fine (my SQLNET & TNSNAMES .ora files are correct) - however, if I use Actuate as a 'Non-Admin' user, i get:
" 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."
along with a "Login Failed (3) (0)" error.
I've trawled various forums and have found this issue several times, but none of the fixes I've tried have made any difference!
Any input will be greatly appreciated!
Many thanks,
Greg -
3. Re: Oracle(tm) client and networking components were not found
Jonah H. Harris Oct 18, 2007 2:04 PM (in response to 603926)What permissions are set on the client directories? -
4. Re: Oracle(tm) client and networking components were not found
603926 Oct 18, 2007 2:20 PM (in response to Jonah H. Harris)Thanks for replying, Jonah.
Would it be just the \bin directory that the Non-Admin User group would need access to (and I guess R&X would be sufficient?) , or would it be wiser to set the permissions on the \ora92 directory to be propagated to all child objects?
Kind Regards,
Greg -
5. Re: Oracle(tm) client and networking components were not found
Jonah H. Harris Oct 19, 2007 1:42 PM (in response to 603926)All parent directories would need to permit your user to access the bin directory. -
6. Re: Oracle(tm) client and networking components were not found
603926 Oct 22, 2007 9:54 AM (in response to 438932)Thanks Jonah - that appears to've solved the problem. Now I have a problem with an actuate script! Hooray! :) -
7. Re: Oracle(tm) client and networking components were not found
d4b897f8-9b26-431b-9003-c6afbd6f4858 Sep 10, 2016 2:33 PM (in response to 438932)Hi,
I have been trying to setup Microsoft ODBC drivers on my Win7 64 bit laptop to work with my code.
Every time it gives me an error msg "Oracle(tm) client and networking components were not found"
ple help me in this. i have tried downloading and installing odbc driver from oracle site but none work.
Can someone guide me as which other software need to be install.
here is the connection string I am using, please help:
strDBConnString = "Driver={Microsoft ODBC for Oracle};" & _
"CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST="&THostName&")(PORT="&TPort&"))" & _
"(CONNECT_DATA=(SID="&TSID&")));Uid="&TUserID&";Pwd="&TPassword&";"
Thanks