Re: Oracle 7 / ODBC / VB

Nicolas Issakides (issakid_at_iway.fr) wrote:

: 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

Hello,
  The ODBC does not support these types of transactions, you may only use   CreateSnapShot or CreateDynaset, ExecuteSql and Execute only. If you want   to connect with two different users, you've to specify the Database ID at   the end of server name in ODBC setup. e.g. t:server:oracle,9999 Choi Chung For,
cfchoi_at_comp.hkbu.edu.hk Received on Mon Feb 27 1995 - 03:35:09 CET