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 SkipVought 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
0
0
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