Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Common configuration and connectivity issues, when setting up Oracle software with the OLE DB Provider for Oracle, can be avoided by verifying that the following details are true:
The correct version of the Oracle client (SQL *Net version) is installed on the computer. Msdaora.dll requires that SQL*Net version 2.3 or higher be installed on the client to enable connectivity from the client machine.
The folder in which the Oracle client was installed is in the computer's path. From a command line prompt, type "path".
The Ociw32.dll is in the <Oracle_Root>\bin folder. There should no other instance of this dll anywhere else on the client computer.
None of the Oracle client component DLLs (eg : core40.dll, ora*dll etc.) should exist any where outside the Oracle_Root folder or its sub-folders.
Only a single Oracle client version should be installed on the computer. Multiple SQL*Nets should not exist on the same client computer. Multiple instances hamper critical Oracle operations, such as TNS Alias lookups.