open Mutiple Databases in a single Transaction

[msrikant]

In Daos and Rdo it is possible to open multiple databases on a single workspace or Environment or what ever that is. But how to open multiple Databases in ADOs. Because in ADOs one database can be opened with a connection information example:

dim con as new adodb.connection
con.open "provider=sqloledb.1;user id=sa;password=;initial catalog=abc;server=ntserver;



Now when I say con.committrans the transctions on con object for abc database is saved. But can I open another database on the same connection. So that jut by saying con.committrans I must be able to commit both databases.

[Lothar Haensler]

from the MSDN documentation:
"ADO transactions are tied to the Connection object, which limits the transaction to a single data source."
Looks like it cannot be done directly. But, using MTS (= MS Transaction SErver) you should be able to implement it.