stored procedure error 170 (Access 2k3)

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
 
M

[MVP] S.Clark

What is the error msg? Is your date delimited with the apostrophe.

i.e.

stpProcName '12/12/2004'
 

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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
stored procedure query 4
Access pass-through query to Oracle 10g stored procedure - results 1
parameter passthrough query 1
Adobe "Wrong type parameter supplied to a PDS procedure" 0
Pass a parameter to a stored procedure from ms access 2
Can't find stored procedure 1

Top