Unable to connect to SQL Server databse - ONLY ON W2K PC's


I keep getting the following error (on W2K PC's ONLY) when trying to start a 3rd party program.
Coonection Failed:
SQLState: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(gethostbyname()().
Connection Failed
SQL State: '08001'
SQL Server Error: 11
[Microsoft]ODBC SQL Server Driver][TCP/IP Sockets]General network error. check your network documentation.

SQL Server Express 2005 is running on a W2K3 server. The XP clients are able to connect without any issues.

Appreciate your help.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Almost appears to be a DNS resolution issue.

Do the W2K machines only point to your DNS?  Are you using a HOSTS file that has bad info in it?

Has the ODBC connection object been set correctly in ODBC applet?

try upgrading ODBC connector on workstations..
If you are able to telnet to the SQL Server from the Win2k PCs, then it could be a MDAC issue on WIn2k PC. If you are unable to even telnet, a firewall or some other app could be blocking the connection.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Can you post your finding please?

saliyamAuthor Commented:
Thanks very much for your input. I reinstalled the latest version of MDAC which solved the issue.
Good. Thanks for reverting.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.