• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

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
0
nexsyis
Asked:
nexsyis
  • 2
1 Solution
 
AmmarRCommented:
0
 
nexsyisAuthor 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?
0
 
AmmarRCommented:
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now