SQL Server does not exist or access denied

[pradeepss]

I have this connection string in my application:
con.ConnectionS tring = "Provider=SQLOL EDB;DRIVER={SQL SERVER};" _
& "SERVER=152.253 .145.23\General ;UID=test;PWD=r unme;DATABASE=t estserver"

the application runs fine on my computer (XP) but has some problem with Windows 2000 computer. I have tried different connection string but no luck. I have tried to ping the server from the problem computer and ping result is ok. i dont know what is the issue

please help!

[iburyak]

To test if it is an application problem or this computer just has broken SQL drivers try to create DSN on that machine with test connection.
If it can't create DSN it means that it has a problem with SQL drivers. The only way I know to fix a problem like this is to install MDAC latest version.


Good Luck.