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 ?
>