Connecting to Multiple databases in a single DSN
This is a discussion on Connecting to Multiple databases in a single DSN within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Is it possible to have one ODBC client configuration connecting to multiple databases? I am trying to port an ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:32 PM
| ||||
| ||||
 Connecting to Multiple databases in a single DSN 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      |
|
02-27-2008, 08:32 PM
| ||||
| ||||
| Re: Connecting to Multiple databases in a single DSN 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 "Ken" <anonymous@discussions.microsoft.com> wrote in message news:02a101c399af$cf9c7650$a601280a@phx.gbl... > 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 > > |
Linear Mode
