General information
Category:
Database DAO/RDO/ODBC/ADO
>Is there any way to open multiple connections for a recordset? The reason I ask this is because we are using a sql statement that uses data from two different ODBC Drivers and we need to open both for the recordset to work.
Multiple connections for the same recordset? Not possible AFAIK. How are you using this SQL statement? (I mean, does it work and how)
What is your backend database? If any of the two backends is SQL Server you might be able to use a linked server to treat the other DB as just another SQL Server database.
The alternative is to open two recordsets and process the data on the client side.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only