Running a Store procedure from DAO

S

SF

Is it possible to execute a store procedure from DAO. If so, could someone
give me some direction.

Thank you

SF
 
L

Larry Linson

SF said:
Is it possible to execute a store procedure from DAO. If so, could someone
give me some direction.
Click to expand...

Use a Passthrough Query, in which you have coded the Server Database's SQL
Syntax for running a Stored Procedure.

That SQL Syntax will differ from server DB to server DB.

Some years ago, while recovering from surgery, I used Sybase SQL Anywhere on
my home computer to allow me to develop off-site; when it was time to merge
my work into the on-site database that had a back end Informix database, the
syntax for calling a stored procedure was the only thing that had to be
modified.
 
S

SF

Thank you.

SF
Larry Linson said:
Use a Passthrough Query, in which you have coded the Server Database's SQL
Syntax for running a Stored Procedure.

That SQL Syntax will differ from server DB to server DB.

Some years ago, while recovering from surgery, I used Sybase SQL Anywhere
on
my home computer to allow me to develop off-site; when it was time to
merge
my work into the on-site database that had a back end Informix database,
the
syntax for calling a stored procedure was the only thing that had to be
modified.
Click to expand...
 

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

sql stored procedure 1
Execute SP async with ability to stop execution 0
SQL Server Stored Procedure timeout 3
Stored Procedure 18
Creating a querydef of a stored proc on Sql Server 8
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Delete index using DAO 11
How to create the Visio diagram from already created Stored procedures 1

Top