Easysoft
ODBC Drivers for Oracle, SQL Server, Firebird, ISAM, InterBase, Sybase, MS Access & more.

Easysoft Data Access

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

Article : 00995
Last Reviewed : 11th December 2008
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?
Yes
No
Maybe
 
* Please select one option based on your first choice:
I'm very satisfied
I think it will help, but I haven't tried it yet
It is helpful, but I need more information
It is helpful, but hard to understand
Seemed relevant in search results, but didn't help me
The information is incorrect
The page contains one or more broken links
 
  Suggest new content or let us know how we can improve this content:

 
  (* Required Fields)   



© 1993 - 2012 Easysoft Limited. All rights reserved.