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: 428
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