angel7170
asked on
Cannot find NT Oracle server DLL
Hello,
I am trying to install SAP BusinessObjects Data Services 4.1 SP2 in Windows 7.
Data Repository is 64-bit Oracle database.
PATH to oracle: C:\Oracle\product\11.2.0\c lient_1\bi n;
I get an error below when I tried to connect using Data services designer.
"Cannot find NT Oracle server DLL (OCI.DLL). ensure that oracle is installed and the PATH variable points to correct lib directories"
Please assist. OCI.DLL file is found in the path mentioned above. I am not sure what is missing.
I am trying to install SAP BusinessObjects Data Services 4.1 SP2 in Windows 7.
Data Repository is 64-bit Oracle database.
PATH to oracle: C:\Oracle\product\11.2.0\c
I get an error below when I tried to connect using Data services designer.
"Cannot find NT Oracle server DLL (OCI.DLL). ensure that oracle is installed and the PATH variable points to correct lib directories"
Please assist. OCI.DLL file is found in the path mentioned above. I am not sure what is missing.
If SAP BusinessObjects Data Services 4.1 is a 32Bit app, you need the 32Bit Oracle client and drivers installed.
ASKER
I thought data services 4.1 is a 64bit. Am I wrong?
Don't know. I'm only an Oracle person not a Business Objects person. From a quick Google looks like it can be either.
Do you have the oci.dll in C:\Oracle\product\11.2.0\c lient_1\bi n?
Do you have the oci.dll in C:\Oracle\product\11.2.0\c
ASKER
Yes, the oci.dll is found in C:\Oracle\product\11.2.0\c lient_1\bi n
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Make sure you have both the 32 and 64 bit ODBC connections installed on the machine.
mlmcc
mlmcc
ASKER
Thanks, We have 32-bit oracle client installed and not 64-bit. I will install 64-bit and see how it works. thank you