Query with Two Different DSN

Posted by morant on Stack Overflow See other posts from Stack Overflow or by morant
Published on 2010-04-29T13:03:09Z Indexed on 2010/04/29 13:07 UTC
Read the original article Hit count: 431

Filed under:
|

I have a query:

The "X" tables are from one data source and the "Y" table is from another...but there is join between the data sources. I can't seem to figure out how to enter the two different connection strings for this to run.

ConnectionString="Dsn=Xdb;uid=xxx;pwd=xxxxxxx" ProviderName="System.Data.Odbc" ConnectionString="Dsn=Ydb;uid=xxx;pwd=xxxxxxx" ProviderName="System.Data.Odbc"

Is this possible...am I just missing something?

© Stack Overflow or respective owner

Related posts about multiple

Related posts about dsn