DSN-LESS Connection Strings in Pass Thru QueryDef

C

Cleatus

Hello,

For the Applications I support, I prefer to use DSN-LESS connection strings
rather than DSN.

The DSN-LESS connect string works wonderfully for all my ADO objects.
BUT
I doesn't seem to work at all for Pass thru queries. Can I make a PassThru
query
operate with the DSN-LESS Connect String.
 
D

Douglas J. Steele

You must use an ODBC DSN-less connection string (and you must prefix it with
ODBC;)
 

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

How to create DSN Less connection on pass through query? 0
DSN-Less Connection Help 10
Trusted Connection in Pass-trough query... 4
DSN Less Connection 2
Pass-Through Query Help 12
ODBC Pass-through query with parameter from table 5
Issues Connecting to SQLServer 17
Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End 7

Top