Troubleshooting

This topic describes the most common error related to:

· OLE Initialization or OLE Automation

· Oracle Network

· General Protection Faults

Additional information on errors can be found in the Oracle Database Error Messages.

OLE Initialization or OLE Automation Errors

The most frequent cause of OLE Initialization and Automation errors is missing or incorrectly installed software. Ensure correct installation of the software specified later. Then make sure that you have specified method and property names correctly and that you have declared all "Oracle objects" as type "object".

Causes and Solutions for OLE Errors

Possible Cause	Solution
Your system does not contain the Microsoft OLE Automation or runtime files or these files are out of date.	Please make sure you have latest versions of files such as `mfc42.dll, oleaut32.dll, ole32.dll, etc. installed.`
The Oracle Objects for OLE object information was not registered in the Windows registration database.	Either reinstall Oracle Objects for OLE or run `regedt32.exe` to register information. See OO4O Redistributable Files.
Your system does not contain the Oracle Required Support Files: -oraclient.dll -orageneric.dll -oracommon.dll -oracore.dll -oranls*.dll,	Please look up Oracle Objects for OLE readme.htm file to see what version of Oracle Client is required. Next, install the required Oracle Client.
Your system does not contain Oracle Networking or its files are not on the PATH.	Install Oracle Networking product or add to your PATH environment variable the directory where these files are located.
You have misspelled a method or property name.	Check the documentation to determine the correct spelling.
You have referenced a method or property from the wrong object.	Check the documentation to determine the correct object.
Your system does not contain `oraansiVER.dll`	Reinstall Oracle Objects for OLE and select the "Oracle Objects Server" option, or add to your PATH environment variable the directory in which these files are located. NOTE: VER refers to the version.

Oracle Network Errors

The most frequent cause of Oracle Network errors is incorrectly specified connection information. The connection information for Oracle Objects for OLE is specified differently than when using ODBC. Please verify that you have specified connection information correctly, and then make sure your network connection is working properly before using Oracle Objects for OLE. The appropriate Oracle Network documentation contains information about testing your connection and about any Oracle Network error that you may receive.

Oracle Network Errors

Possible Cause	Solution
Incorrect Connect property or argument to the OpenDatabase method.	See the topics on the Connect property or the OpenDatabase method for examples.
Incorrect DatabaseName property or argument to the OpenDatabase method.	See the topics on the DatabaseName property or the OpenDatabase method for examples.
Your system does not contain the Oracle Networking product.	Install Oracle Networking software.

General Protection Faults

The most frequent cause of GPFs is installing Oracle Objects for OLE while other applications are running that require the OO4O automation server, Oracle Required Support Files or OLE. To avoid this, install Oracle Objects for OLE immediately after starting Windows and before running any other application.

General Protection Faults

Possible Cause	Solution
Duplicate Oracle Objects for OLE files exist in SYSTEM directories or along the PATH.	Remove any duplicate files. The files `oip10.dll` and `oip10.tlb` should only be located in the `ORACLE_BASE\ORACLE_HOME \bin` directory.
Duplicate Oracle Required Support Files DLLs exist in the SYSTEM directories or along the PATH.	Remove any duplicate files. Typically, the Oracle Required Support Files DLLs (`oraclient.dll, orageneric.dll, oracommon.dll, oracore.dll, oranls*.dll`) are located in `ORACLE_BASE \ORACLE_HOME\bin`.
Duplicate OLE DLLs exist in the SYSTEM directories or along the PATH.	Remove any duplicate files. The OLE DLLs (listed in the Oracle Objects for OLE Files topic) should only be located in `\system` directories.