Oracle 7 / ODBC / VB

i try a very simple application in VB with ODBC. I connect to a server (WINDOWS Nt or RS6000) running Oracle 7. and i find following problems when i try to create dynaset again Oracle tables,

1. current version of ODBC drivers (supplied by Oracle or Microsoft) does not support transaction (commit, rollback and begin)
2. i'm unable to connect to the sever twice with 2 differents usernames in the same program
3. following statement does not work :

        select * from user1.table1

 Access goes me an error : unable to find 'user1.mdb '

If somebody can confirm all this and has found a solution in order to build query and update tables located in differents users through dynaset (using VB/ODBC/DATA control)

regards.

Nicolas Issakides
issakid_at_iway.fr Received on Wed Feb 22 1995 - 21:53:47 CET