• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:


I'm getting this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #398) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
/export_to_excel.asp, line 18

I have an ASP page that goes against SQL Server 7.0.

It runs a stored proc and returns the result into the page. The page works sometimes and the other times it brings back the above error.

Also I have the feature on the page to export the result to excel and it's giving me the same problem.

2 Solutions
Heres a couple of little articles on it:



dont know if it has anything to do with it but you werent getting any other replies so i thought id give you something to do ;o)
Does ASP support synchronize as Java does?

Otherwise caching could be usefull, if that is doable in your situation. This will remove some load from the export_to_excel.asp as you have stored the already generated stuff elsewhere. The change of having deadlocks on the export function should therefor be somewhat less.

jaze95Author Commented:
It's happening on the page with the export to excel feature. That page isn't coming up
jaze95Author Commented:
I submit some dates that run's a stored proc and returns a result to a page. On this page I have a button that will allow a user to export to excel.

This is more of a SQL problem than an ASP problem...

I would suggest running SQL Profiler to determine what's causing the deadlocks...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now