Re: ADO,ODBC and transaction

Hallo,

If two SQL*Plus editors are making this it will work correct. The first client/transaction don't see changes of the other second client/transaction

I thought the sense of ADO is to be database undependent (at least for easy things like updates or inserts)
and the IsolationLevel method of the ADO.Connection object should encapsulate the transaction level.

If this easy things doesn't work the complete ADO can be forgotten in muliple user enviroment

George

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> schrieb im Newsbeitrag news:3d3c6602$0$8510$cc9e4d1f_at_news.dial.pipex.com...
> <rant>
> Then the simple solution is to create a one column table with a datatype
of
> number, lock the whole table and update it for each transaction. This is
> entirely database independent and doesn't even require changing the
> definition of the database across platforms.
> </rant>
>
> Your solution is already not database independent because you don't have
> triggers in access or autonumber in oracle. use the power of the platform.
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
> "Sheridan" <gh_at_hakom.at> wrote in message
> news:EzV_8.3$Eh.163_at_stuart.coltnet.at...
> > Sorry, I have forgotton to explaine that I do not won't to use oracle
> > specific things like SET TRANSACTION LEVEL SERIALIZABLE
> > because our libraries should be independent from the used database.
> >
> > Therefore I want to use "SELECT Max(ID) FROM Table" in combination with
> the
> > isolation level to get the ID
> > because Access uses AutoValue to genarte an unique key
> > and Oracle use a trigger for that.
> >
> >
> >
> >
>
>
Received on Tue Jul 23 2002 - 10:06:45 CDT