Kbase 11365: Connecting, disconnecting and reconnecting db w/ HLI
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Connecting, disconnecting and reconnecting db w/ HLI
If a user is running HLI and trying to connect, disconnect and
reconnect to a database, they will get the error that the database
is already connected on the reconnect.
The reason it works this way is that with SQL there is always an
active transaction. So, upon connect, a transaction is started,
but a disconnect doesn't rollback, since there may be other connected
databases. So, if a commit occurs between the disconnect and the
next connection, and the second connect will start a new
transaction.
SO in case I've lost anyone, with HLI, if a user wants to connect and
reconnect, they should issue a commit work in their embedded sql c
code.
Progress Software Technical Support Note # 11365