i am trying to populate one record set using the recordset.open method, but i want to populate it from 2 data sources, not just one (using two connections) ... the add/update record proceedure does not appear practical, is there a way to just name 2 data sources when opening the record set so ONE record set is created from the two different databases also USING two different sql statements for the data sources?? I am using asp 3.0 on windows 2000 server and multiple access databases which i basically want to do multiple database search on .... yielding one search result to then manipulate further ...

will appreceiate any advice ....

Hi there,

AFAIK, there is no (easy) way to merge two Recordsets in ADO. You could do some complicated stuff by using AddNew on the first Recordset to add each record from the second Recordset. However, I think that will kill performance.

If you are able to get your data as ready as can be from the database (filtered, sorted, whatever), you could use the GetRows method of the Recordset to get your data from the Recordsets in a two-dimensional array. You can then merge these two arrays, and do some client side data manipulating (skipping duplicate records, sorting, whatever). Again, this won't be very fast, unless you're working with relatively small datasets.

I take it there is no way to merge the data in the database, so your ASP pages can retrieve data from just one connection? You could look into linking servers or databases to get your data from a single source. For example, in SQL Server, you may get away by using a UNION on two queries that retrieve data from two databases / SQL Servers.....

Hope this helps a bit,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.