Kbase 21172: ODBC Dsrv: ct_bind, ct_command, ct_drop, ct_connect - SYBASE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/09/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress ODBC DataServer 9.x
SYMPTOM(s):
S1000: [INTERSOLV][ODBC SQL Server driver] [SQL Server] ct_connect (): network packet layer: internal net library error: Net-Lib protocol driver call to read data failed
S1000: [INTERSOLV][ODBC SQL Server driver] [SQL Server] ct_bind (): user api layer: external error: An invalid locale was supplied in the CS_DATAFMT structure.
S1000: [INTERSOLV][ODBC SQL Server driver] [SQL Server] ct_command (): user api layer: external error: This routine cannot be called while results are pending for a command that has been sent to the server
S1000: [INTERSOLV][ODBC SQL Server driver] [SQL Server] ct_drop (): user api layer: external error: This routine can be called only if the command structure is idle.
CHANGE:
Select Method changed
CAUSE:
There is a property under the ODBC driver configuration named 'Select Method'. This value determines whether database cursors are used for Select statements. When set to 0, the initial default, database cursors are used.
When set to 1, Select statements are executed directly without using database cursors. When set to 1, the data source is limited to one active statement and one active connection.
SYBASE ODBC Driver sets the "Select Method" to "1-Direct" by default.
FIX:
Start ODBC Administration, go to the DSN configuration, and under the
Performance tab, make sure that Select Method is set to '0-Cursor'.
Reference to Written Documentation
Sybase System 11 ODBC Driver Help