freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] 'Invalid cursor state' with protocol versions 7.0 / 8.0

From: "Fabricio Chalub" <CHALUB AT fgv.br>
To: <freetds AT lists.ibiblio.org>
Subject: [freetds] 'Invalid cursor state' with protocol versions 7.0 / 8.0
Date: Mon, 12 Jan 2004 14:14:22 -0300

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

[freetds] 'Invalid cursor state' with protocol versions 7.0 / 8.0, Fabricio Chalub, 01/12/2004