Pass-Through Query / Multiple ODBC Connections

T

Tyro

When creating a Pass-Through Query, is there a way to create two or more
“ODBC Connect Strâ€s in the Property Sheet?

ODBC;DSN=DMH_Hub;Description=DMH_Hub on
MZPRODEDWADHOC;UID=mzbrosb;DATABASE=DMH_Hub;Trusted_Connection=Yes

ODBC;DSN=DW1;Description=DW1 on MZPRODDW;UID=mzbrosb;Trusted_Connection=Yes

Or better yet, is there a way to specify the connection of the query to
automatically be whatever connection the linked tables are using?
 
D

Douglas J. Steele

Pass-through queries run on the server, not in Access, therefore unless the
DBMS you're using on that server supports multiple connections, you're out
of luck. Note that you'd have to define the connections on the server, not
in Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC DSN query issue 1
Trusted Connection in Pass-trough query... 4
Access Pass-through Query to SQL Server 7
ODBC Pass-through query with parameter from table 5
Pass-Through Query Error 1
Pass Through Make Table 7
Other users can't execute my pass through queries 3
SQL pass thru query from code always propting for DSN 5

Top