RE: Locking via DBI

You can't, maybe with an OLEDB module.  The settings should be made directly
in the database and then everyconnection will automatically use them.  Not
sure, but there are probably ways to set different locking levels based on
the user id, etc...

Ilya Sterin

-----Original Message-----
From: David Billingham [mailto:david@wholiveshere.net]
Sent: Thursday, March 22, 2001 4:49 PM
To: Sterin, Ilya; dbi-users@perl.org
Subject: Re: Locking via DBI


Hi

Thanks for your reply.

> This is usually implemented by your DB package.  Access has table and
record
> locking ability so you must read the docs to implement this on the access
> side.

Sure - but I don't understand how to get at this functionaility via
Perl\DBI. Is there a standard ODBC way to do this - I've searched, but can't
find it?

Thanks

David Billingham


> Ilya Sterin
>
> -----Original Message-----
> From: David Billingham
> To: dbi-users@perl.org
> Sent: 3/22/01 10:55 AM
> Subject: Locking via DBI
>
> Hi
>
> Can anyone tell me how to lock tables\recordsets via the DBI interface -
> or
> tell me where I should be looking for this info.
>
> I am using DBD:ADO to connect to an Access database on an NT server.
>
> Thanks in advance.
>
> David Billingham
>

• Locking via DBI by David Billingham
• RE: Locking via DBI by Sterin, Ilya
• Re: Locking via DBI by David Billingham
• RE: Locking via DBI by Sterin, Ilya