all groups > sql server odbc > may 2006 >
You're in the

sql server odbc

group:

ODBC Connections


ODBC Connections Simon
5/12/2006 1:49:02 AM
sql server odbc:
I have a network with 6 machines sitting on it.

All PC`s are configued in the same way. 5 of the machines connect to a SQL
server via ODBC with no problems.

The sixth PC however does not connect to the server giving the following :-

Connection Failed
SQL State '01000;
SQL Server Error: 11001
TCP/IP Sockets Connection Open
GetHosting Name

General network error.


I`m connecting via aTCP/IP on port 1433.


Does anyone have any idea why I am encountering these problems ?
RE: ODBC Connections AAO
5/12/2006 5:58:01 AM
did you try 'telnet YourDBServerIP 1433'?

[quoted text, click to view]
RE: ODBC Connections Simon
5/12/2006 7:22:02 AM
I`m probably being a sponge but I don`t seem to get anything using that
command from any of the PC`s.

[quoted text, click to view]
Re: ODBC Connections Sue Hoegemeier
5/12/2006 11:28:06 AM
You should get an error if SQL Server isn't listening on
1433. Or you should blank screen with the title of the
window changing to Telnet <Your Server> if you have
successfully established a telnet connection on that port.
It just sounds like you are connecting.

-Sue

On Fri, 12 May 2006 07:22:02 -0700, Simon
[quoted text, click to view]
Re: ODBC Connections Henning
5/13/2006 3:17:40 PM
Firewall?
/Henning

"Simon" <Simon@discussions.microsoft.com> skrev i meddelandet
news:1359348E-85DA-43DD-AA79-313F4F92DF94@microsoft.com...
[quoted text, click to view]

Re: ODBC Connections Simon
6/6/2006 7:39:02 AM
The firewall setup is the same accross all the machines so I don`t think is
causing the problem.

[quoted text, click to view]
AddThis Social Bookmark Button