[Zope-DB] Invalid Cursor State

Charlie Clark charlie@begeistert.org
Tue, 24 Jun 2003 12:34:13 +0200


On 2003-06-24 at 03:02:40 [+0200], Liart Junior wrote:
> I'm using Zope 2.6.1 (Win32 Plataform) with ZODBCDA to connect to a MS Sql
> 2000 Server and I get the message:
> 
> Error Type: sql.error
> Error Value: ('24000', 0, '[Microsoft][ODBC SQL Server Driver]Invalid 
> cursor state')
> 
> When I debug de db.py of ZODBCDA Product, the error occurr because the 
> command SQLFreeStmt stay commented. When I remove the '#' occur the 
> folowing error:
> 
> Error Type: RuntimeError
> Error Value: external method could not be called because it is None
> 
> Can anyone help me?

Not with ZODBCDA

> Have other way to connect to SQL 2000?

Yes, try using mxODBC and ZmxODBCDA from egenix.com.

Charlie