Kbase 21161: ODBC Dsrv: 24000: [MERANT][ODBC Sybase driver] Invalid cursor state
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/23/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress ODBC DataServer 9.x.
SYMPTOM(s):
24000: [MERANT][ODBC Sybase driver] Invalid cursor state
Error is experienced when running an application against Progress ODBC DataServer to Sybase database.
CAUSE:
MERANT's ODBC Driver for Sybase sets the "Prepare Method" to "1- Partial", as opposed to "2- Full" for Sybase's ODBC Driver.
This value determines whether stored procedures are created on the Server for every call to SQLPrepare.
When set to 0, stored procedures are created for every call to SQLPrepare, which can decrease performance when processing static statements.
When set to 1, the driver creates stored procedures only if the statement contains parameters. Otherwise, the statement is cached and executed directly at SQLExecute time.
When set to 2, the driver never creates stored procedures.
FIX:
Start ODBC Administration, go to the DSN configuration, and under the Performance tab, set Prepare Method to '2- Full'.