Re: Attempted Simultaneous Access causes "Could not lock file"

Hmmm.... the ASP.NET application is only reading.

I can have multiple perl programs writing to the database, simultaneously. I
wrote both programs. One of the most important features of a database, I
thought, was simultaneous access by multiple processes.

The perl code is just doing "INSERT"s and the ASP.NET is only doing Selects.
Is there not some setting that needs to be adjusted to allow multiple
readers and writers?

I understand that the MSAccess GUI needs exclusive access when editing a
table definition, but I'm not doing that.

Thanks,
Siegfried


"Vincent Johns" <vjohns@xxxxxxxxxxxxxxxxxx> wrote in message
news:qk5%e.1297$4h2.97@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Siegfried Heintze wrote:
>
> > I have a screen scraper written in perl that populates the same database
> > every night with new additional information.
> >
> > Why is it that when I try to simultaneously write to the database with
perl
> > and read it with my ASP.NET UI I get "could not lock file" from ASP.NET?
> >
> > Thanks,
> > Siegfried
>
> I don't know the details of your system, but this behavior seems quite
> reasonable. If ASP.NET needs exclusive use of some resource (such as
> your database), and some other process currently has access to the
> resource, then ASP.NET should definitely have to wait until nobody else
> is using it. Maybe you can schedule the activities for different times.
>
> -- Vincent Johns <vjohns@xxxxxxxxxxxxxxxxxx>
> Please feel free to quote anything I say here.


.

Relevant Pages

  • PostgreSQL and Customer Database
    ... I've been working on both SQL and Perl for a while now, ... get them all onto an SQL database, and be able to keep track of sales, as ... the database available to customers and potential customers, ...
    (perl.beginners)
  • Ways of ensuring integers in the database are seen as numbers in perl?
    ... I'd like my database returned integers to look like integers to Perl but they currently don't until I add 0 to them. ... The reason for this is that adding 0 to a Perl scalar seems to persuade Perl the scalar is an integer. ... $num as returned from database: ...
    (perl.dbi.users)
  • Re: How to access MS Access from Perl?
    ... if you were to later migrate to MS SQL Server or Oracle ... minimize your load on the database server's compiled procedure cache. ... On the other hand, if startup time for your perl script is an issue, and ... slightly preferable to the bulkier DBI + DBD::ODBC. ...
    (comp.lang.perl)
  • Re: Attempted Simultaneous Access causes "Could not lock file"
    ... storing it in my MSAccess database. ... I just wrote another test perl program and pasted in the massive SELECT ... >> I can have multiple perl programs writing to the database, ... > It probably needs exclusive access to the entire Table if it's modifying ...
    (microsoft.public.access.tablesdbdesign)
  • Re: LAMP - Program Design with Perl
    ... > information and queries the MySQL database. ... > Maybe there are Perl modules to faciliate this kind of task? ... so I think it worthwhile to second Anno's suggestion on this method (eg. ... Aside from the hint about dispatch tables, ...
    (comp.lang.perl.misc)
Loading