Wednesday, March 21, 2012

Error in SQL

I have an application in VB 6.0, that uses a connection with SQL 2000.

A process was running when the following error ocurred:

[DBNETLIB][ConnectionRead(recv()).]General network error.Check your network documentation.

The error number is: - 2147467259

Before this error, I was having a timeout expire (Err.Number = -2147217871) problem with was correct with an Error Handling.

This routine is very hard, normally it last 2 or 3 days.

I see something about this, telling to install the DBMSLPCN.DLL. Will the instal of this DLL resolve my problem?

What are the effects of this install?

Valmir>> This routine is very hard, normally it last 2 or 3 days.
Do you umean the error lasts for 2 or 3 days?

Do you close the connection in the app and open a new one when you get an error? If not then try that as it may just be a network error that has lost you the connection.

If you mean you have a single query that lasts two or three days then redesign it.|||Thanks for help, I will try reconnect.

The routine last 2 or 3 days is not just one procedure and yes all the process.

No comments:

Post a Comment