Re[2]: Set connection to read only and back to writable?



Hallo Tim,

Tuesday, October 18, 2005, 2:18:56 PM, you wrote:
....
TB> No, it just means that no database-independant API has been defined
TB> so you'll need to use database-specific code.

>> > drivers. Knowing which driver you're using might help us...
>>
>> It is mysql and perhaps Oracle.

TB> Umm, now I come to look at it I see that mysql's "SET READ_ONLY=1"
TB> command only works at the global level ("SET GLOBAL READ_ONLY=1")
TB> and that's probably not what you want. I've no time to dig further.

TB> Anyone know how a connection can be set to read-only in MySQL and/or Oracle?

For Oracle:
set transaction read only;

cu
Wieland mailto:wieland@xxxxxxxxxxxxxxx

.



Relevant Pages

  • RE: Trouble Installing DBD::ODBC with postgresql
    ... Ask your local Oracle ... Windows "Server" license) and install the Windows version of Personal ... ODBC is not remote access to a database, ODBC is a layer on top of ... native drivers to present applications a unique interface. ...
    (perl.dbi.users)
  • Re: Trouble Installing DBD::ODBC with postgresql
    ... all you need is a set of Oracle client libraries to compile and run DBD::Oracle on Linux. ... ODBC is not remote access to a database, ODBC is a layer on top of native drivers to present applications a unique interface. ... If you link a C program against an ODBC library, it can communicate with any database for which you can find an ODBC driver. ... If you can establish a TCP connection from your linux box to port 1521 on one of the Sun servers, chances are very good that you can use a native connection. ...
    (perl.dbi.users)
  • Re: Disappearing Application -- Oracle Related
    ... > database using current 9.2 Oracle Windows drivers. ... using ADO instead of the BDE and copy and paste your transation ...
    (comp.lang.pascal.delphi.misc)
  • Re: MDAC and Oracle9
    ... We have tried Oracle's native driver, the MS OLE DB driver for Oracle ... and the MS OLE DB Driver for ODBC Drivers using either the Microsoft ... We are getting error messages like this from W2K Server SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Wrong Return Value from statement.executeUpdate(query)
    ... On 20.04.2007 17:50, Joe Weinstein wrote: ... Oracle would need a "BEGIN delete ...; delete ...; END;". ... since JDBC 1.0. ... For example accessing meta data - although there is a clear defined interface drivers still choose to interpret arguments differently. ...
    (microsoft.public.sqlserver.jdbcdriver)