How to get a single recordset from two Data Sources using ADO 
Author Message
 How to get a single recordset from two Data Sources using ADO

I have two data sources.   1 - SQL Server, 2 - SQL Anywhere

I want a query to return a single recordset containing fields from a table
in data source #1 with fields from a table in data source #2 when SSN fields
in both tables are equal, using ADO.

Can this be done using ADO alone?   If so How?    I'm trying to mimick what
MS-Access does when you "Link" two tables to 2 different data sources and
then perform a query to join them.

TIA



Tue, 07 Jan 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Using ADO Data Control on User Control as Data Source

2. Batch update for multiple tables using single ADO Recordset (VB )

3. max recordsets using a single ado connection

4. Batch update for multiple tables using single ADO Recordset (VB )

5. Create User Control as Data Source Using ADO Data Control

6. Requery Data Source Object based on ADO Recordset

7. Requery Data Source Object based on ADO Recordset

8. ADO Recordset as TDC Data Source

9. Create Single Data Set from mulitple data sources

10. Getting error message when using SQL for data source in ADOC

11. Newbie:Getting a recordset from a stored procedure using ADO

12. Not getting data using WHERE clause between table and recordset

 

 
Powered by phpBB® Forum Software