We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

General network error between windows 2000 and sqlexpress 2008

Medium Priority
497 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

Top Expert 2010
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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?
Top Expert 2010

Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.