Pass-Through Query / Multiple ODBC Connections

  • Thread starter Thread starter Tyro
  • Start date Start date
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?
 
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.
 
Back
Top