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 ?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 ?
>|||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:
[vbcol=seagreen]
> did you try 'telnet YourDBServerIP 1433'?
> "Simon" wrote:
>|||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:
[vbcol=seagreen]
>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:
>|||Firewall?
/Henning
"Simon" <Simon@.discussions.microsoft.com> skrev i meddelandet
news:1359348E-85DA-43DD-AA79-313F4F92DF94@.microsoft.com...[vbcol=seagreen]
> 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:
>
SQL[vbcol=seagreen]
following :-[vbcol=seagreen]|||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...
> SQL
> following :-
>
>

ODBC Connection to SQL

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 ?Is there error actually GetHostByName?
On the PC that can't connect, try pinging the server by
server name and try pinging the server by IP and see if
there are any issues with pinging by name. If there are then
check that client for network issues as it's having problems
resolving the server name.
Otherwise, the issue you are seeing is often due to MDAC
issues. Try updating or reinstalling on that PC. You may
also
want to check the MDAC installation using component
checker. You can download component checker and MDAC
versions from:
http://msdn.microsoft.com/data/mdac...ds/default.aspx
-Sue
On Fri, 12 May 2006 01:17:02 -0700, Simon
<Simon@.discussions.microsoft.com> 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 ?
>