Sybase doesn't allow more than one active statement when retrievingresults without cursor

[Alex Budin]

Hello,

I have a report with multiple sub-reports all of wich use pass-thru queries to run one Sybase stored procedure with different parameters. Most of the users logged on the same machine have no issues running the report. However some users at some point get following error "Sybase doesn't allow more than one active statement when retrieving results without cursor". All the users belong to the same sybase group and have necessary permissions. Not sure what can couse this.

Appreciate your help,
Alex


EggHeadCafe - Software Developer Portal of Choice
A "Make Virtual Directory 2.0 Here" Windows Explorer Context Menu Utility
http://www.eggheadcafe.com/tutorial...2c-92655c5551fa/a-make-virtual-directory.aspx

 

[Banana]

Hello,

I have a report with multiple sub-reports all of wich use pass-thru queries to run one Sybase stored procedure with different parameters. Most of the users logged on the same machine have no issues running the report. However some users at some point get following error "Sybase doesn't allow more than one active statement when retrieving results without cursor". All the users belong to the same sybase group and have necessary permissions. Not sure what can couse this.

Appreciate your help,
Alex


EggHeadCafe - Software Developer Portal of Choice
A "Make Virtual Directory 2.0 Here" Windows Explorer Context Menu Utility
http://www.eggheadcafe.com/tutorial...2c-92655c5551fa/a-make-virtual-directory.aspx

This is something to do with ODBC and possibly a limitation of Sybase or
the ODBC driver supporting Sybase.

Basically, active statement means a statement that is running. The
driver may have sent multiple statements without waiting for the first
statement to finish retrieving the rows.

You may want to check the documentation on Sybase & the ODBC driver and
verify whether it supports multiple & active statement (note that
multiple statements and active statements may be a separate setting) and
enable the option where appropriate. In case where active statement is
not supported at all, see if you can either disable multiple statements
or restrict connection pooling the idea being that you would want to
force Jet to open a new connection in order to satisfy multiple requests
for each subreports.

If you need more information, take a look at the guide:

http://tinyurl.com/ODBCGuide

There's several references linked as well, maybe you will be able to
find out something toward the solution.

Best of luck.

 

[Alex Budin]

Thanks for help. However i ran a test on the same machine so to me it doesn't seem to be related to Sybase driver.



Banana wrote:

Re: Sybase doesn't allow more than one active statement when retrieving results without cursor
02-Oct-09

Alex Budin wrote

This is something to do with ODBC and possibly a limitation of Sybase or
the ODBC driver supporting Sybase

Basically, active statement means a statement that is running. The
driver may have sent multiple statements without waiting for the first
statement to finish retrieving the rows

You may want to check the documentation on Sybase & the ODBC driver and
verify whether it supports multiple & active statement (note that
multiple statements and active statements may be a separate setting) and
enable the option where appropriate. In case where active statement is
not supported at all, see if you can either disable multiple statements
or restrict connection pooling the idea being that you would want to
force Jet to open a new connection in order to satisfy multiple requests
for each subreports

If you need more information, take a look at the guide

http://tinyurl.com/ODBCGuid

There's several references linked as well, maybe you will be able to
find out something toward the solution

Best of luck.

EggHeadCafe - Software Developer Portal of Choice
..NET Lock, Logoff, Reboot, Shutdown, Hibernate, Standby
http://www.eggheadcafe.com/tutorial...8834-04366ce32c96/net-lock-logoff-reboot.aspx