Posted by Greg D. Moore \(Strider\) on 02/23/07 18:46

"The Man" <LeJon7881@gmail.com> wrote in message
news:1172253510.989866.118890@m58g2000cwm.googlegroups.com...
> Hello All:
> I am in desparate need of assistance. We are using an application
> called PaperVision Enterprise which takes scanned invoices and puts
> them into a database for the purpose of easy reference to any scanned
> invoice in the db. 2 weeks ago while trying to perform a 'match and
> merge' of the newly scanned docs, we received a Run-time error
> '-2147217871 (80040e31)": Timeout expired message. After being told by
> the company who supports this software that they couldn't help me
> since it is using a MS SQL Server Table Lookup I started googling the
> error with minimal success. I am not very proficient with SQL so I'm
> kind of stuck. I have narrowed this down to an ODBC run-time error,
> but looking for some kind of guidance as to how I can resolve it. Any
> info would be greatly appreciated. We are using MS SQL Server 2000.
>

Really not much to go on here.

It's not clear to me, did this happen just once? Or all the time?

Can you open query analyzer and do a sp_who2 on the server in question?
It's possible something has a lock on that table. Killing that (and
determining who/why) should solve your problem.



--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

[Back to original message]