From my own knowledge:

The connection to the DBE opens the DBE only. A TurboImage db is opened when
the first query involving one of its dataset is invoked. Then, the database
stays opened until the user disconnect from the DBE. I don't think users
connected at the same time to a DBE can share a connection to TurboImage. I
would rather think, on the reverse, that a user may use multiple connections
to the same TurboImage db thru the same connection to the DBE, because of
different cursors opened (at the same time) on the same dataset.
In your case, if the user connects to the DBE, queries TurboImage and the
disconnect from the DBE, I'd say yes: this implies a pair of DBOPEN/DBCLOSE
each time!

Michel Gauthier

Leonard Berkowitz <[log in to unmask]> wrote in message
news:F4B1826B1A21D211AEC5006008207AF401E23F85@dogbert.csillc.com...
> Scenario:
>
> An external user is logged into an HP9000 system. Programmatically, a
connect is
> created to an Allbase DBE on an HP3000; a query is issued via ODBC, and
the
> connection is released. This happens repeatedly during the day, say
500-600 times by
> several different users.
>
> Question:
>
> Can I assume that each successive query, even by the same user results in
> DBOPEN/DBCLOSE pair on the attached TurboImage data base?
>
> Thanks,
> ========================
> Leonard S. Berkowitz
> mailto:[log in to unmask]
> phone: (617) 972-9400 ext. 3250
> fax:   (617) 923-5555
>