Windows·65,590 discussions

odbc connection

Locked

Here is my problem. I am trying to establish an odbc connection to a remote sql 2000 server and I can’t. I am going from one network to another network. I can ping the server from my workstation. I can ping from the server to my workstation. I can also establish an odbc connection from the remote sql server to one of my localsql servers. I just can’t connect to the remote sql server. I get a connection failed sql state 01000 sql server error 10060. Any help would be appreciated.

Topic

Reply To: odbc connection

In reply to odbc connection

do you think entry in hosts file would help?

Reply To: odbc connection

In reply to Reply To: odbc connection

Poster rated this answer.
put it in lmhosts and did not work.

Reply To: odbc connection

In reply to odbc connection

Hi,
it must be a BUG: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol
http://support.microsoft.com/default.aspx?scid=kb;en-us;306865

or
FIX: RPC Clients Unable to Login to SQL Server with Windows Authentication
http://support.microsoft.com/default.aspx?scid=kb;en-us;311111

or
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932

Success

Leopold

Reply To: odbc connection

In reply to Reply To: odbc connection

I couldn’t get your links to work can you please repost.

Reply To: odbc connection

In reply to odbc connection

go to http://support.microsoft.com/
and search on:

kb 306865

KB 311111

kb 287932

Leopold

Reply To: odbc connection

In reply to Reply To: odbc connection

Did all that no luck..

Reply To: odbc connection

In reply to odbc connection

If you’re going through a firewall make sure that port 1433 is open. Maybe make sure it’s open on their firewall if applicable also.

Reply To: odbc connection

In reply to Reply To: odbc connection

No firewall is between us. I think the problem is that they are patting their local addresses and that the translation is getting lost through the Cisco router when it is coming back to us.

Reply To: odbc connection

In reply to odbc connection

going to repost with new info.

Reply To: odbc connection

In reply to odbc connection

This question was closed by the author

[Author]

Replies