Ole db error -- sql server connect

Julian
5/17/2004 9:58:40 PM

Hi frnds,
New problems evryday ..
we had migrated our intranet website(in asp) frm win 2k t
win 2k3 last week , for 2 days all went ok but then the
trouble(s) started ...
frm yest we are getting an error time in and again
"Microsoft Ole DB provider for ODBC Drivers
error '80040e31'"
I have no clue as 2 why it is happening ...
the backend is sql server 2000....

plz help
Regards

julian
5/19/2004 12:14:33 AM

somebody plz suggest me what todo this prob is very
serious....searched the net did not find anything useful

[quoted text, click to view]

Sue Hoegemeier
5/19/2004 5:55:52 AM

That's the error number for Timeout expired. If using ADO,
try increasing the command timeout property. You can find an
example of this at:
http://www.able-consulting.com/ADO_Faq.htm#Q14
You may also want to consider using the OLE DB provider for
SQL Server instead of the generic OLE DB provider for ODBC
drivers. Generally you will get better performance, more
functionality.

-Sue

On Mon, 17 May 2004 21:58:40 -0700, "Julian"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : Ole db error