December 17, 2004 at 12:06 pm
SELECT Xf.SSN, eel.SEX
From [System2].[DB].[DBO].DATAFIle Xf
Join OTHERInfoFile eel on Xf.SSN = eel.SSN
Where Xf.Over65 = 'Y'
ERROR: OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.
[OLE/DB provider returned message: Timeout expired]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].
Any idea what is causing the timeout. DATAFIle and OTHERInfoFile are on two different servers...the query runs for sometime before it stops.
Thanks!
December 17, 2004 at 12:46 pm
see Microsoft KB article: 31453
January 17, 2005 at 12:53 am
I am getting the same error, and I have tried the response recommended in the KB article, but I am having the same problem. I am running a strored procedure through osql against an msde sql server database. The procedure takes data from a remote server and brings it into my msde database. It works against a number of tables, and the small ones run fine, and the larger ones run occasionally. When they fail, I get this error: Msg 7399, Level 16, State 1, Server x, Line 1 OLE DB provider 'MSDASQL' reported an error. Execution terminated by the provider because a resource limit was reached. [OLE/DB provider returned message: Microsoft][ODBC SQL Server Driver]Timeout expired].
I moved this msde database from another computer, where it had been working fine. Do you have any ideas?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply