stored procedure error 170 (Access 2k3)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I am having problems with a SQL Pass-Through Query & a Stored Procedure.

If I try to call a date parameter, say @StartDate, I get a error 170 no
matter what I try. However if I use Query Analyser on the the same Stored
Procedure everything works perfectly fine.

Any advice on what I should do?

Many thanks in advance
Mark
 
What is the error msg? Is your date delimited with the apostrophe.

i.e.

stpProcName '12/12/2004'
 
Back
Top