VB5 / ODBC / Ingres question 
Author Message
 VB5 / ODBC / Ingres question


I'm developing a VB5 app that access an Ingres 6.4 database.  I had some
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, _

    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,
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
options on the ING_SET variables,  but I want to add them also inside the
for extra security.

Thanks in advance.


Fri, 06 Oct 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Connecting vb4 to an ingres database using datadirect odbc driver

2. Intersolv ODBC with Ingres 6.4/04

3. ODBC Drivers Ingres 6.4 Database

4. ODBC driver for Ingres searched

5. Ingres/ODBC rec fetch in 2 secs ?

6. Need HOT ODBC driver for Ingres !

7. Help with connecting to Ingres through ODBC.

8. VB, Ingres, ODBC problem

9. ODBC transition question from VB4 to VB5, the connection object

10. VB5 and Client Access ODBC Question

11. VB5 and Oracle 7 ODBC question???

12. Urgent question about VB5/RDO Oracle8/ODBC


Powered by phpBB® Forum Software