Link to home
Start Free TrialLog in
Avatar of nexsyis
nexsyisFlag for United States of America

asked on

General network error between windows 2000 and sqlexpress 2008

I have recently upgraded from SQLEXPRESS 2000 to 2008.  This windows 2k box can connect to the old server without any issues.  I have flussed the DNS, setup WINS on the new server, purged WINS and tried to reconfigure OBDC connection as well, but get the same error.  I am able to ping the server without any packet loss.  I have 4 other machines that work just fine with the new server.


Connecting to SQL Server with ConnectionString:  Provider=SQLOLEDB;server=201.1.1.3\SQLEXPRESS,1433;database=WINMED
[DBMSSOCN]General network error. Check your network documentation., Microsoft OLE DB Provider for SQL Server
ASKER CERTIFIED SOLUTION
Avatar of AmmarR
AmmarR
Flag of Bahrain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nexsyis

ASKER

How did you know that would fix the issue?  Could you tell me where i could read up more on what that actually did to fix the problem?
Experience bro, this issue happened to me several times, and tried many things. and MDAC worked with me so i suggested it for you.

but usually what i do, isi  take the error message and search for it in google or well know developers sites like stackoverflow.com and read posts and discussion.

thats how you learn.. good luck

Regards