Re: VB5 with Oracle. Hangs because of transactions

From: Christian J. Bauer <christian.bauer_at_passau.netsurf.de>
Date: 1998/04/19
Message-ID: <6hcfma$q3n$1@einstein.pnm.net>#1/1

Domingues wrote in message <01bd69cf$0d7db1d0$320281ac_at_pdo8brg>... > ...
> Set Wks = CreateWorkspace("ManutWorkspace", "prodata", "prodata",
dbUseODBC)
> Set Conn = Wks.OpenConnection("ManutConnection", dbDriverNoPrompt,
False, odbcWinCP + ";")

You should avoid those DAO Workspace stuff when connecting to external (ODBC) databases. In your case, the workspace is handling the Transactions and this could be the reason for your "deadlock". You should use RDO instead. DAO is only neccessary when you want JET. You should use DAD only when connecting to local Databases (dBase,Access, Paradox etc...) and dont want to use the ODBC overhead.

When using DAO you can also avoid the workspaces using "OpenDatabase".

Chris Received on Sun Apr 19 1998 - 00:00:00 CDT