Pass thru query help

J

Joe

I have a reporting system I created that links to a SQL
server 2000 database. I would like to start using SQL
stored procedures to run some very complex reports.

I can create a pass thru query that will run the SP. But I
have 2 issues.
1) I can not pass parameters from a form (start and end
dates for example) to it.
2) when I hit the button to run it, it asks for an ODBC
connection. (I need this Automatic)
The tables are linked already thru an ODBC connection but
the pass thru does not seem to see it.

Any help would be greatly appreciated.
Joe
 
L

Les

Hi,
If you build your sql for the pass-thru in your form,
(on click event when you hit the button?), you should be
able to add your parameters.
If you open your pass thru query in design view, then
click on properties, you should be able to put your odbc
connection info in there.

HTH
 

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 Thru Query 3
Pass-Through Query Error 1
Pass Parameter to stored procedure in pass thru query 7
Reserved Error -7711 Pass Thru Query 5
SQL Pass Thru from normal qry 2
Incorrect date in pass-thru query 1
Setting ODBC Connection string of Pass thru query dynamically 1
Pass Thru Query Connection 1

Top