I wanted to create a report based on a stored procedure at a Sybase Database

Creating the synonym gives me this error:

(FOC1400) SQLCODE IS 7713 (HEX: 00001E21) 
: Stored procedure 'fmc_pages.dbo.p_brokers' may be run only in unchained transaction mode.
The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode. 

(FOC1405) SQL PREPARE ERROR. 

I wonder if anybody knows what this is and how I can solve the problem.

This message has been edited. Last edited by: FrankDutch,

Hi,

If your login has the proper roll you could execute
SET CHAINED OFF

just prior to executing your stored procedure. My guess is that you don't. Altering the procedure can be a way around.

You are left with only one alternative. You MUST execute the stored procedure from within a transaction. That is what the error message is so poorly trying to tell you. You can do one of two things. 1) Set auto Commit to true. This will allow the stored proc to execute without this error message. 2) start a transaction prior to executing the stored proc and commit when complete.