ODBC Connections
This is a discussion on ODBC Connections within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have a network with 6 machines sitting on it. All PC`s are configued in the same way. 5 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 10:10 PM
| ||||
| ||||
 ODBC Connections 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 ?      |
|
02-27-2008, 10:11 PM
| |||
| |||
| RE: ODBC Connections did you try 'telnet YourDBServerIP 1433'? "Simon" wrote: > 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 ? > |
|
02-27-2008, 10:11 PM
| |||
| |||
| RE: ODBC Connections I`m probably being a sponge but I don`t seem to get anything using that command from any of the PC`s. "AAO" wrote: > did you try 'telnet YourDBServerIP 1433'? > > "Simon" wrote: > > > 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 ? > > |
|
02-27-2008, 10:11 PM
| |||
| |||
| Re: ODBC Connections 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 <Simon@discussions.microsoft.com> wrote: >I`m probably being a sponge but I don`t seem to get anything using that >command from any of the PC`s. > >"AAO" wrote: > >> did you try 'telnet YourDBServerIP 1433'? >> >> "Simon" wrote: >> >> > 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 ? >> > |
|
02-27-2008, 10:11 PM
| |||
| |||
| Re: ODBC Connections Firewall? /Henning "Simon" <Simon@discussions.microsoft.com> skrev i meddelandet news:1359348E-85DA-43DD-AA79-313F4F92DF94@microsoft.com... > I`m probably being a sponge but I don`t seem to get anything using that > command from any of the PC`s. > > "AAO" wrote: > > > did you try 'telnet YourDBServerIP 1433'? > > > > "Simon" wrote: > > > > > 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 ? > > > |
|
02-27-2008, 10:12 PM
| ||||
| ||||
| Re: ODBC Connections The firewall setup is the same accross all the machines so I don`t think is causing the problem. "Henning" wrote: > Firewall? > /Henning > > "Simon" <Simon@discussions.microsoft.com> skrev i meddelandet > news:1359348E-85DA-43DD-AA79-313F4F92DF94@microsoft.com... > > I`m probably being a sponge but I don`t seem to get anything using that > > command from any of the PC`s. > > > > "AAO" wrote: > > > > > did you try 'telnet YourDBServerIP 1433'? > > > > > > "Simon" wrote: > > > > > > > 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 ? > > > > > > > |
Linear Mode
