MS Access, scripts clashing
- From: Nathan.Neff@xxxxxxxxx
- Date: 20 Oct 2005 17:58:09 -0700
Hello,
I have a script which writes to an Access 2002 database.
I'm using DBI over DBD::ADO with this connection string:
DBI:ADO:Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;
I have two scripts that run at the same time, and both of them write to
the same Access database.
I'm constantly getting this error from the scripts:
Win32::OLE(0.16) error 0x80004005: "Unspecified error"
in METHOD/PROPERTYGET "Execute"
Description : Could not update; currently locked.
HelpContext : 5003218
HelpFile :
NativeError : -72156238
Number : -2147467259
Source : Microsoft JET Database Engine
SQLState : 3218
---------------------------------------------------------------
The error quits appearing when one of the scripts completes (Hence,
unlocking the database, I guess).
The only way that I can get two or more scripts to write the same DB is
to open/close the $dbh every time I write a record to the database.
This seems like a waste of resources, and seems like there should be a
solution.
Has anyone else had this problem? I've searched for DBI Access Locked,
etc. etc. and couldn't come up with anything.
Maybe I'm missing an Access-specific parameter that I should use in the
connect string?
Thanks,
--Nate
.
- Follow-Ups:
- Re: MS Access, scripts clashing
- From: Nathan . Neff
- Re: MS Access, scripts clashing
- Prev by Date: DBD::Sybase 1.05_1 and Perl threads
- Next by Date: Re: Odd DBI behavior
- Previous by thread: DBD::Sybase 1.05_1 and Perl threads
- Next by thread: Re: MS Access, scripts clashing
- Index(es):
Relevant Pages
|
|
