I'm using perl on a windows machine.
I have a perl batch process populating an MSAccess database and a ASPX C#
front end reading from the (same) MSAccess database. The ASPX/C# works fine
as long as there is not a perl program trying to populate the database. If
there is a perl program populating the database, then the ASPX/C# dies with
a "could not lock file" error or " Could not use ''; file already in use."
Depending on whether the C# is using OLEDB or ODBC.
I've been posting in the ADO and MSAccess forums for help but they seem to
be stumpted.
I tried to reproduce the problem by copying the massive SQL SELECT statement
out of the C# code and pasting it into a little perl test program. The perl
runs fine!
Here is my select statement that I use in all the perl programs (readers and
writers):
my $dbh = DBI->connect("dbi:ODBC:driver={Microsoft Access Driver
(*.mdb)};dbq=c:\\Inetpub\\heintze\\keyword-job-search\\$sDatabase","Admin","
") or die "$DBI::errstr\\n";
Is there anything in this connect statement that might exclude other
readers?
Here is the connection statement I am using in C# that is causing the
errors:
Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\Inetpub\heintze\keyword-job-search\job-search.mdb;Uid=Admin;
Pwd=;
I was using oledb and switched to ODBC since perl is using ODBC. The
symptoms did not seem to change.
Here is the error I get when perl has the file open:
Could not use ''; file already in use.
To summarize: it always works fine with perl reader. It works fine with
C#/ASPX reader and no simultaneous access. It breaks when perl is
INSERTing/SELECTing and C#/ASPX is SELECTing.
I guess this is really a Microsoft ADO problem but I'm out of ideas. I was
hoping that someone might have some ideas here.
Thanks,
Siegfried
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
