access stored procedure

[BRADLEY21]

I tried to pass a variables to a stored procedure on MSSQL however it does not work. The code looks like this. Anyone have ideas?

=SQLEXE(MyConnection,"myproc(var1,var2)&quot

 

[agoeddeke]

Bradley21,

Do either one of these work?

=SQLExec(MyConnection, "{CALL myproc (?var1, ?var2)}&quot
or
=SQLExec(MyConnection, "{CALL myproc (?@var1, ?@var2)}&quot

Andy

 

[Mike Gagnon]

agoeddeke

=SQLExec(MyConnection, "{CALL myproc (?var1, ?var2)}&quot

That just looks strange...Are you missing a bracket?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[rgbean]

Mike,
It looks balanced to me. Note: Technically there are two set of balanced parenthesis ()'s and one set of Braces {}'s.

Brackets are [].

Rick

 

[Mike Lewis]

Bradley,

It will be easier to diagnose the problem if you could tell us:

- What error are you seeing?

- What is the code in your stored procedure?

Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk