FlySpeed Data Export

Online help

Connecting to Oracle source database

Contents  Previous  Next

Problem:

I get the Initialization error "SQL*Net not properly installed" while trying to connect to Oracle database. What should I do?

Solution:

You have to install the Oracle client software in order to connect to Oracle databases.

• You can download the Oracle Instant Client at http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
• To download the standard Oracle Database 10g Client or later, choose your client platform at http://www.oracle.com/technology/software/products/database/index.html
• You can download the Oracle Database 9i Client for Microsoft Windows 98/2000/NT/XP at: http://www.oracle.com/technology/software/products/oracle9i/htdocs/winsoft.html

You will need to register, but this is free and you can then access other useful pages on the Oracle web site.

Alternatively, contact your Oracle Database Administrator for the Oracle distribution CD. The standard Oracle Client is included in the Oracle distribution.

Problem:

I get the Initialization error "Could not locate OCI dll" while trying to connect to Oracle database. What should I do?

Solution:

Make sure that "<OracleHome>\bin" folder is in PATH, and that some version of oraxy.dll, e.g., ora71.dll, ora72.dll, etc. exists in that folder or elsewhere in the PATH. For Oracle8, the OCI dll is named OraClient8.dll. For Oracle9, the OCI dll is named OraClient9.dll.