SQL Pass-through Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Olgun - 09 Mar 2005 19:25 GMT

Hi,

I want to be able to reference a connection included in a module funcion
through the "ODBC Connection Str" property found in the properties window of
a "SQL Pass-Through Query".

Any ideas if this is possible, and if yes, how can I do this?

Any suggestions would be appreciated.

Thanks.

Reply to this Message

Alex Dybenko - 09 Mar 2005 19:34 GMT

To get a pass-through query connection string you can use following syntax:

debug.print currentdb.querydefs("MyQuery").Connect

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Olgun - 09 Mar 2005 19:49 GMT

Thank you for your response Alex. I think I wasn't very clear describing my
problem, let me try to rephrase it.

Ultimately I want to connect to an Oracle database, for some reason the DSN
connection is failing but works when I do this with DSN less connection using
ADO.

So I want the SQL-Pass through connectstr to reference the ADO connection
included in a module. Make sense?

Thanks again for your response.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks.

Reply to this Message

Alex Dybenko - 09 Mar 2005 20:59 GMT

Hi,
not sure you can use ADO connection string, but you can try to use dsnless
connection string like described here:
http://www.accessmvp.com/djsteele/DSNLessLinks.html

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Thank you for your response Alex. I think I wasn't very clear describing
> my
[quoted text clipped - 23 lines]
>>
>> Thanks.

Reply to this Message

Douglas J. Steele - 10 Mar 2005 01:29 GMT

The sample to which Alex pointed you doesn't actually explicitly spell it
out, but all you need to specify for the connection string is the
appropriate ODBC DSN-less string. Check what Carl Prothman has at
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm The
"secret" is that you must precede the connection string with ODBC;

Note that you cannot use an Ole DB connection string: Access will only
recognize the ODCB one.

Signature

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

> Thank you for your response Alex. I think I wasn't very clear describing
> my
[quoted text clipped - 23 lines]
>>
>> Thanks.

Reply to this Message