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

Hi,

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.
saliyamAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
itsmeinConnect With a Mentor Commented:
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.

SC
0
 
Netman66Commented:
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?

0
 
rehanahmedsCommented:
try upgrading ODBC connector on workstations..
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
itsmeinCommented:
Can you post your finding please?

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

SC
0
All Courses

From novice to tech pro — start learning today.