Calling Sybase Procedure from Ms Access

[mehrnosh]

Hi
Am trying to Call a Sybase Back-end procedure from
Ms Access, but it's not working, the procedure had around
10 parameter ( char, numeric and datetime).
.execute command give error
also tried using CreateQueryDef is giving runtime error

Any help would be very helpfull

Thanks

 

[jrbarnett]

Are you using a Pass through query when trying to execute it?
This means that Access won't make any attempt to interpret your SQL code and just act as a front end to Sybase and return any results.

John

 

[mehrnosh]

Hi John

Have got the solution u have to create a workspace
and a connection to the ODBC and then .execute with
all the parameter and there value same as u give in sybase
back-end


thanks