#74 kinterbasdb doesn't work with Firebird 2.1

[Mih Van]

I've got Firebird release 2.1.0.17798, and kinterbasdb 3.1.2 source (from ubuntu linux 7.10, I am using).

I've build kinterbasdb package with new libfbclient.2.1.0 library and when I am trying to execute my script, I am getting the following error:

---------------------------------------------------------
File "../../restore.py", line 54, in restore_table
c.execute(ins, params);
File "/var/lib/python-support/python2.5/kinterbasdb/__init__.py", line 1584, in execute
self._ensure_transaction()
File "/var/lib/python-support/python2.5/kinterbasdb/__init__.py", line 1622, in _ensure_transaction
self._con._ensure_transaction()
File "/var/lib/python-support/python2.5/kinterbasdb/__init__.py", line 933, in _ensure_transaction
self.begin()
File "/var/lib/python-support/python2.5/kinterbasdb/__init__.py", line 739, in begin
_k.begin(self._C_con, self.default_tpb)
kinterbasdb.OperationalError: (-901, 'begin transaction: invalid parameter in transaction parameter block. ')
-----------------------------------------------------

The "ins" variable contains insert query, but I've tried with any query and got the same error.

[Jonathan Rogers]

I'm trying the Ubuntu 8.10 (Intrepid) package of kinterbasdb version 3.2 and I'm getting a very similar error:

-----------------------------------------------------
>>> cur.execute("select * from PRODUCT")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
kinterbasdb.OperationalError: (-901, 'begin transaction: \n invalid parameter in transaction parameter block')
>>> con.dialect
3
>>> con.charset
>>> con.server_version
'WI-V6.3.1.17910 Firebird 2.1'
>>>
-----------------------------------------------------

The server is running on Windows 2003. FlameRobin 0.8.6.1652 on the same Ubuntu system works fine.

[Jonathan Rogers]

I'm trying the Ubuntu 8.10 (Intrepid) package of kinterbasdb version 3.2 and I'm getting a very similar error:

-----------------------------------------------------
>>> cur.execute("select * from PRODUCT")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
kinterbasdb.OperationalError: (-901, 'begin transaction: \n invalid parameter in transaction parameter block')
>>> con.dialect
3
>>> con.charset
>>> con.server_version
'WI-V6.3.1.17910 Firebird 2.1'
>>>
-----------------------------------------------------

The server is running on Windows 2003. FlameRobin 0.8.6.1652 on the same Ubuntu system works fine.