Query on data from diffrent OleDBConnections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sagaert Johan - 11 Jun 2007 17:55 GMT

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

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 11 Jun 2007 18:16 GMT

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.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> Hi
>
[quoted text clipped - 11 lines]
>
> Johan

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...