Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft Data Access

Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'"?

Article:
00995
Last Reviewed:
4th January 2024
Revision:
1

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.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)