Access DB ASP connection problems
- From: "Georges Erhard" <Georges Erhard@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 28 Jan 2006 03:34:27 -0800
Hey all
Sorry, you'll have to excuse my newbieness.
I'm developing a simple web app in DRW to display some products stored in an
Access DB.
The web site seems to work fine, but I keep getting this error:
Provider error '80004005'
Unspecified error
/giftything/product_pages/productdetail.asp, line 17
Line 17 is as follows:
rsAllProducts.ActiveConnection = MM_connDBGiftything_Products_STRING
It seems to me that when I open a page it maintains exclusive access to the
database and nothing else can access it. If I try to load another page I just
get the above error.
This eventually times out after about 2 minutes or so and you can then load
another page, but then I'm faced with the same problem when trying to open
another page.
Is there a way to close the DB connection when a page has finished loading?
Or is this problem something else entirely?
Any help anyone can give will be much appreciated. Thanks in advance
Georges
.
- Follow-Ups:
- Re: Access DB ASP connection problems
- From: Bob Barrows [MVP]
- Re: Access DB ASP connection problems
- Prev by Date: Re: displaying a only part of a field along with other fields of a recordset
- Next by Date: Re: MS-Access LDB File Still Exists
- Previous by thread: Re: SQL Injection solution:( ?
- Next by thread: Re: Access DB ASP connection problems
- Index(es):
Relevant Pages
|
