Check with your database administrator that the Oracle listener is running.
If the listener is running, is the Easysoft ODBC-Oracle WP Driver connecting to the correct listener port?
By default, the Easysoft ODBC-Oracle WP Driver tries to connect to the default listener port, 1521. However, when connecting to machines where multiple Oracle instances or versions are running, you may need to specify a different port. Check with your database administrator to find out the correct listener port. Specify this port with the Port
attribute in your ODBC data source. For example:
Port = 1522
You can use telnet to check that you can connect to the listener port from you client machine. For example:
telnet myoracleserver 1522
If the listener is listening on the port you specify, you will see output similar to:
Connected to myoracleserver Escape character is '^]'
To exit from telnet, type CTRL-] and then quit
.
If you do not see this output or a "Connection refused" error is displayed, the Oracle listener is not listening on the specified port.