Problem running stored procedure from Sybase Central in Access

crispy02

Registered User.
Local time
Today, 08:31
Joined
Jun 20, 2002
Messages
10
I am having a problem running a stored procedure from Sybase Central in Access. I have no problems running functions. I can run the stored procedure if I hard code the parameter instead of reading from a table. So I know that the ODBC connection is working.

This is what I have in Access:
Select P_PATROLINSP_FLDLIST(readchkhdr.readchkhdr_id,insptype.insptype_id)
from readchkhdr, insptype;


This is the parameter in Sybase Central
ALTER procedure casdba.P_PATROLINSP_FLDLIST(in ai_readchkhdr_id integer,in ai_insptype_id integer)

The error I get is "Database server rejection connection: Invalid parameter(#-735)"

Thanks for any help,
Chris
 

Users who are viewing this thread

Back
Top Bottom