Query on data from diffrent OleDBConnections

[Sagaert Johan]

Hi

Is it possible to run an inner join query if the tables reside in 2 diffrent
mdb files, and so i have 2 connection strings ?

mdbfile1 contains the first table
mdbfile2 contains the secpnd able used in the join.

I'm stuck ,all i can do is to move my second table into the first database.

Is there a solution ?

Johan

 

[Nicholas Paldino [.NET/C# MVP]]

Johan,

No, there isn't. You either have to load the two separate results sets
into memory, and process them accordingly, or, as you are finding out, move
one table into the other database.

If you are using SQL Server at all, you could use the OPENROWSET
function to open the result sets in SQL server and then further manipulate
them there, but that might not be a viable option.