Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection Crash

Status
Not open for further replies.

Almarton

Programmer
Jan 1, 2002
42
BR
ASP IIS MS ACCESS Database Crash

Hi all,

I am developing some ASP pages to query a MS Access DB and it works fine on the web but when testing on IIS 5 it sometimes crash after the first query, sometimes requiring to refresh the next page to avoid the error msg:

Error Type:
Provider (0x80004005)
Unspecified error

I suspect the DB is in a locked state that preventing the next Conn.Open command. But I repeat in the web it works fine, only in my PC that this happens...

Does anyone know the cause for that? Is there any ADO library or so missing?

Thanks;

@lex.

Alexandre @lmarton Marton
almarton@task.com.br
 
If you are running NT 4 workstation, Win2k Pro, or XP Pro then you have a connection limit to 10. Maybe your hitting that limit.

Does this happen when you are stress testing the application?

-Bad Dos
 
No,

But I may have find out what was the bug.

I had two virtual directories pointing to the same path under IIS5 (a redundancy).

I eliminated one of them and everything works fine now!!!
I suppose it is not just coincidence.

@lex









Alexandre @lmarton Marton
almarton@task.com.br
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top