General discussion

Locked

odbc connection

By tommymcbrayer ·
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.

This conversation is currently closed to new comments.

10 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to odbc connection

do you think entry in hosts file would help?

Collapse -

by tommymcbrayer In reply to

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

Collapse -

by Curacao_Dejavu 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

Collapse -

by tommymcbrayer In reply to

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

Collapse -

by Curacao_Dejavu In reply to odbc connection

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

kb 306865

KB 311111

kb 287932

Leopold

Collapse -

by tommymcbrayer In reply to

Did all that no luck..

Collapse -

by dmiles 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.

Collapse -

by tommymcbrayer In reply to

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.

Collapse -

by tommymcbrayer In reply to odbc connection

going to repost with new info.

Collapse -

by tommymcbrayer In reply to odbc connection

This question was closed by the author

Back to Windows Forum
10 total posts (Page 1 of 1)  

Related Discussions

Related Forums