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
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