SQL Pass Through

J

J. Joshi

How does one execute a pass through query? Everytime I
have to run it, I have to go to the Machine Data Source
(DSN) window and selet the db that the query resides in.
Is there a way that I can use SQL specific pass through
queries like a regular query?

Joshi
 
L

Les

If you open the passthru in design mode, then click
properties, you can put all your database info in.

ODBC;DATABASE=XXX;UID=XXX;PWD=XXX;DSN=XXX
 

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

Pass Through Query - not returning rows 1
Question on Pass-through Query 4
Pass Through Query .sql query 3
Pass Through Query Question 4
Other users can't execute my pass through queries 2
Pass-Through Query Error 1
Any way to set parameters in Pass-through queries 4
Pass-Through Query / Multiple ODBC Connections 1

Top