Why do I get error "Client unable to establish connection: OS Error: 'Connection refused'" when using the Oracle ODBC driver?

Check with your database administrator that the Oracle listener is running.

If the listener is running, is the Oracle ODBC driver connecting to the correct listener port?

By default, the Oracle ODBC 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 your client machine. For example:

telnet myoracleserver 1522

If the listener is listening on the port you specify, the output is similar to:

Connected to myoracleserver

Escape character is '^]'

To exit from telnet, type CTRL-] and then quit.

If your output is different to this or a "Connection refused" error displays, the Oracle listener is not listening on the specified port.