Hi,

I'm developing a VB5 app that access an Ingres 6.4 database.  I had some
locking
problems so I decided to add the following command after the connection to
the database is made :

    Dim strCommande As String

    Set dbTax = OpenDatabase("Taxation", dbDriverNoPrompt, True, _
            "ODBC;DATABASE=taxation;UID=;PWD=;DSN=taxation")

    strCommande = "set autocommit on"
    dbTax.Execute strCommande

    strCommande = "set lockmode session where readlock=nolock"
    dbTax.Execute strCommande

However, I get a run-time error on the "dbTax.Execute strCommande" line,
something
like unsupported property...  I tried this command with MS Query and it
works, so I'll
like to know how can I make it work in VB5 !!

PS : If I remove the last 4 lines,  my app works fine... but it fills the DB
log file after
a couple of days !!   I included the "set autocommit on" and the "set
lockmode..."
options on the ING_SET variables,  but I want to add them also inside the
app
for extra security.

Thanks in advance.

Christian.