|
| ||||||||||||||||||
Easysoft ODBC-SQL Server DriverWhy do I get error "Client unable to establish connection: OS Error: 'Connection refused'"? |
|
Check that the SQL Server instance that you are trying to connect to is running.
If the SQL Server Browser or listener service is running, you can use tdshelper to display a list of all the running SQL Server instances on your network. On the machine where the Easysoft ODBC-SQL Server Driver is installed:
cd /usr/local/easysoft/sqlserver/bin ./tdshelper -i
On the SQL Server machine, "SQL Server <instance>" will be listed in output of the net start command, if the SQL Server instance is running.
If SQL Server is listening on a fixed TCP port, check that you can use telnet to connect to the port that you have specified in the data source:
telnet hostname port
where hostname is the host name or IP address of the machine where SQL Server is running and port is the port number that you have specified with the Port attribute. If the SQL Server instance is listening on this port, you will see output similar to:
Connected to myserver Escape character is '^]'
To exit from telnet, type CTRL-] and then quit.
If you do not see this output or a "Connection refused" error displays, SQL Server is not listening on the specified port. Contact your database administrator for the correct SQL Server port.
If you are using the correct port but are unable to connect with telnet, the SQL Server instance may not allow remote TCP/IP connections. See Why do I get error "Client unable to establish connection: Server not configured for TCP connection"?
