C
cunger28
I have one SQL server with 3 db's that I need to connect to. I have 3 odbc's
set up for each database. I'd like to be able to perform pass-through
queries, but it looks like i can only do one odbc per pass through. The 3
db's have elements that need to link across the board.
I've read about adp's, but it looks like i can access one database at a time
that way too. I'd like to avoid linking a bunch of tables if possible.
Is there a way to have more than one database in a passthrough connection
string?
Thanks,
set up for each database. I'd like to be able to perform pass-through
queries, but it looks like i can only do one odbc per pass through. The 3
db's have elements that need to link across the board.
I've read about adp's, but it looks like i can access one database at a time
that way too. I'd like to avoid linking a bunch of tables if possible.
Is there a way to have more than one database in a passthrough connection
string?
Thanks,