nexsyis
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=2 01.1.1.3\S QLEXPRESS, 1433;datab ase=WINMED
[DBMSSOCN]General network error. Check your network documentation., Microsoft OLE DB Provider for SQL Server
Connecting to SQL Server with ConnectionString: Provider=SQLOLEDB;server=2
[DBMSSOCN]General network error. Check your network documentation., Microsoft OLE DB Provider for SQL Server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER