Link to home
Start Free TrialLog in
Avatar of asifalig
asifalig

asked on

error -2147467259 + vb+ sql server 2000

Dear experts!


We have a VB app that has been running successfully for months, and now we are
recieving this error...........

[DBNETLIB] [Connection Read (recv).]General Network Error. Check your Newtork Documentation. -2147467259
Connection Failure.

Has anyone come across similar problems, or have a fix?

I m using SQL SERVER 2000 + VB 6.0 + crystal report 8.5
please suggest!
ASKER CERTIFIED SOLUTION
Avatar of Nightman
Nightman
Flag of Australia 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
And to quote from that article:

The only available workaround is to disable OLE DB Resource Pooling, which ADO uses by default. You can do this by adding "OLE DB Services = -2" to the ADO Connection string, as shown here: 'For SQLOLEDB provider
 'strConnect = "Provider=SQLOLEDB;server=SQL7Web;OLE DB Services = -2;uid=AppUser;pwd=AppUser;initial catalog=northwind"

' For MSDASQL provider
'strConnect = "DSN=SQLNWind;UID=Test;PWD=Test; OLE DB Services= -2"