Prev: how do i perform a Count(Distinct) query for 2 different column va
Next: 学习 M本0602班 郑建姣
From: Tyro on 24 Nov 2009 17:26
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?
--
Tyro from Missouri
From: Douglas J. Steele on 24 Nov 2009 17:38
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Tyro" <Tyro(a)discussions.microsoft.com> wrote in message
news:F63030EA-14D1-464E-8840-75A0DB337E70(a)microsoft.com...
> 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?
> --
> Tyro from Missouri


 | 
Pages: 1
Prev: how do i perform a Count(Distinct) query for 2 different column va
Next: 学习 M本0602班 郑建姣