🚀 go-pugleaf

> Why does Active Sesssions > 1 or == 0 indicate support for overlapped
> transactions ?

OLEDB References:
The maximum number of session objects that can be active at one time.

For some providers, this value represents the number
of active connections or a combination of session objects
and active connections. This value can reflect a limitation
imposed by either the provider or the data store.
At minimum, if the value is zero, there is NO SPECIFIED LIMIT
or the limit is unknown; or if the value is one, there can be only
one active session; or lastly, if the value is greater than one,
there is a known limit. The number of supported sessions
is provider-specific.

Active session - this is session with active transaction

> > In this case, InterBase OLEDB provider must be throw exception with
> > error code ....
>
> If InterBase OLEDB provider supported overlapped transactions, the
starting
> a second transaction from a session should not fail. The problem with
> ADO/OLEDB and overlapped transactions is that there is no way to specify
> which transaction to commit and/or rollback if two or more overlapped
> transactions are running at the same time.
No. One session - one transaction (or list of nested transactions)

For OLEDB - You can create multiple session (~ multiple transaction)
For ADODB - You cannot create multiple sessoion. But, see again:

http://www.ibprovider.com/eng/examples/example_09_02.html

This is sample of custom ActiveX component for clone ADODB.Connection to
separate transaction in single connection. Source of this component included
on commercial kit of IBP :-)

> > Apropos, current status of transaction (session object) you can
> > receive througn ITransaction::GetTransactionStatus
>
> Good information to know. However I am not sure how to go from ADO objects
> to the underlying OLEDB interfaces. In this example I would want to go
from
> my ADO Connection object to its underlying ITransaction interface. How
would
> I do that ?
You can access to session object through ADOConnectionConstruction /
ADOConnectionConstruction15 interfaces (see ADODB SDK).

Welcome on www.ibprovider.com :-)

Regards,
Dmitry Kovalenko