Database locked.

[urich]

Upon running my asp application, the application locks up.
I now see a file with .ldb in the fpdb folder which I
cannot delete. Apparently this is a duplicate version of
the database that the application is trying to access.

How do I get this application from keep locking up?

[Martin CLAVREUIL]

hello,

as access has no transaction coordinator any R/W access to the database will
lock it in read only mode. This a normal behaviour.

So, you have to connect your db just once, putting the connexion in the
application object.

"urich" <urich@wlake.org> a écrit dans le message de
news:011801c38060$69055a00$a101280a@phx.gbl...

> Upon running my asp application, the application locks up.
> I now see a file with .ldb in the fpdb folder which I
> cannot delete. Apparently this is a duplicate version of
> the database that the application is trying to access.
>
> How do I get this application from keep locking up?

[Bob Barrows]

urich wrote:

> Upon running my asp application, the application locks up.
> I now see a file with .ldb in the fpdb folder which I
> cannot delete. Apparently this is a duplicate version of
> the database that the application is trying to access.
>

No - the ldb file is the lock file which the first user of the database must
be able to create. It is not a duplicate of your database. It contains
information about which users are currently using the database. Subsequent
users of the database must be able to write to this file if it exists (so
their name can be added to or deleted from the list of current database
users), or create the file if it does not exist. The last user of the
database must have permissions to delete this file, or else the database can
remain locked.

This means that users of your database must have Change permissions (read
and write) for the folder containing your database file. With asp, this
means that the IUSR_machine account must be granted this level of
permission, as well as the IWAM_machine account. see:
[url]http://www.aspfaq.com/show.asp?id=2062[/url]

HTH,
Bob Barrows

[Bob Barrows]

Martin CLAVREUIL wrote:

> hello,
>
> as access has no transaction coordinator any R/W access to the
> database will lock it in read only mode. This a normal behaviour.

Not true.

>
> So, you have to connect your db just once, putting the connexion in
> the application object.
>

This is the worst thing you can possibly do if you want your application to
scale. See this:
[url]http://www.aspfaq.com/2053[/url]

Bob Barrows