Saturday, February 25, 2012

ODBC source error message on Vista 64

I tried to create an ODBS syste data source but I get this error:

Connection Failed:

SQLState:'01000'

SQL Server Error:10061

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect())

Connection Failed:

SQLState:'08001'

SQL Server Error:17

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Server does not Excist or access denied.

Thanks

The connection string you are using is either not right are the server is not reachable. For investigating this issue you should answer some questions. Is the server on the same server as the SQL Server ? Which version are you using ? Are you using a named instance ? Are you using the default port or any other manually configured one ? DO you h ave a firewall enabled, if yes, did you configure exceptions for outgoing communication for the designated port mentioned above ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment