[freetds] 'Invalid cursor state' with protocol versions 7.0 / 8.0
Fabricio Chalub
CHALUB at fgv.br
Mon Jan 12 14:14:22 EST 2004
Hi,
Using either protocol version 7.0 or 8.0, the following
Python script works (ie, inserts the value on the table)
but also raises with the following exception:
mxODBC.InternalError: ('24000', 0, '[FreeTDS][SQL Server]Invalid cursor state', 2363)
If I switch to protocol version 4.2 the error disappears.
Is this known behavior? Any ideas for making this work cleanly
with protocol 7.0/8.0? I'm connecting to a SQL Server 2000.
I am using:
freetds 0.63.dev.20040112
iODBC 3.51.1
unixODBC 2.2.7
mxODBC 2.0.6
---
import mx.ODBC.iODBC
cto = mx.ODBC.iODBC.DriverConnect ("DSN=sqlserver;UID=YYY;PWD=XXX")
areaI = "INSERT INTO some_table (c1,c2,c3,c4,c5,c6) VALUES (?,?,?,?,?,?)"
c2 = cto.cursor()
c2.execute(areaI, ('C', 1, 'T1', 'T2', 'T3', 'T4'))
Thanks,
Fabricio
More information about the FreeTDS
mailing list