Connecting to Multiple databases in a single DSN -- sql server odbc

Ken
10/23/2003 2:51:27 PM

Is it possible to have one ODBC client configuration
connecting to multiple databases?

I am trying to port an application to SQL Server and reuse
the references to the multiple databases:

e.g.

strQuery = "Select db1.table1.*,db2.table2.* from
db1.table1 (inner join db1.table1.field1 on
db2.table2.field2) where ..."

Thanks in advance

Brannon Jones [MS]
10/23/2003 5:55:57 PM

The ODBC API does not support this, but you can use the "Distributed Query"
feature of SQL Server to do what are you trying to do. Look it up in SQL
Books Online for more information.

Brannon

[quoted text, click to view]

sql server odbc : Connecting to Multiple databases in a single DSN