Re: adOpenForwardOnly

gemilie wrote on 16 May 2006 13:41:07 -0700:

The backend of my database is being placed in a read only state some
how. I use several queries with the following statements:
rsCCurrentStatus.Open sCCurrentCustomstatus, dcnn, adOpenForwardOnly,
I close the connection and set it to nothing each time. If a user is
running that sub and closes it without letting it finish could this
place my backend in a read only state?

What database? What makes you think it becomes read only? Are you using a
client-side or server-side cursor?

The adForwardOnly cursor only allows moving forward in the recordset, so it
won't be that. In your other post you use adLockReadOnly too - this again
only affects the current cursor, preventing it from making changes, it does
not stop other connections from making changes as long as they have the
right settings.

Dan


.

Relevant Pages

  • Re: Huge memory comsumption of ADODB Connection object
    ... Why I said the Connection ... to nothing, the memory used by my app doesn't decrease, only when I close the ... I take the same opinion as you do, if the cursor doesn't return ... resultset to client, no impact will be imposed to client. ...
    (microsoft.public.data.ado)
  • Re: VB6 ADO DB2 - Update Problem
    ... Jeweils ein Feld der beiden ... Was veranlasst Dich zu der Annahme, dass Daten eines Recordsets mit ... Man kann eine Connection auch ohne ein solches Ungetüm öffnen, ... Warum serverseitiger Cursor? ...
    (microsoft.public.de.vb.datenbank)
  • Re: psycopg, transactions and multiple cursors
    ... >> opening a connection thus the app doesn't suffer so much. ... first time a change is made to the database. ... >> what you want is a nested and not a new cursor. ... B e careful that you don;t confuse the DB API curosrs with the cursors ...
    (comp.lang.python)
  • Re: Please help with cmd.execute select SQL?
    ... > What is the proper format for my SQL str using command.execute? ... RecordCount requires the use of an expensive cursor. ... and connection immediately, releasing the connection back to the connection ...
    (microsoft.public.inetserver.asp.general)
  • Re: Likely KDE exploit on 4.1
    ... The cursor immediately ... An easy test is to pull the network connection, or down the net devices and see if the problem persists. ... Sometimes X/Y motion is seen backwards when the device was setup funny. ... Direct replies will be blacklisted. ...
    (comp.unix.bsd.openbsd.misc)