Re: ODBC/Sybase Stored Procedure w/Output Variables

> I am trying to run a stored procedure from Sybase using an ODBC connection. > The SP has two output variables. When I run the same SQL code (obviously > with the appropriate values) from an ISQL window, I receive two results, one > returns no rows, and the other returns the desired values. When I try to run > the SP using the following code, I can only retrieve the result that returns > no rows. I am guessing that I need to use the odbc_prepare function, but I > cannot find good enough documentation to tell. Maybe I need do this as a > transaction ??? how ??? Any help would be greatly appreciated ... The combination of odbc_prepare() / odbc_execute() currently supports only input parameters. If it would be possible, which doesn't seem to be the case, to execute several statements with one odbc_exec(), it should be possible to retrieve the output like with a normal query. I think ISQL doesn't use odbc but the native Sybase protocol. Maybe there is some special syntax required to get multiple statements executed? This should be in the Sybase odbc driver documentation. -Andreas