Subject kinterbsdb 3.3 + firebird 2.0.6 + Python 2.6 not working under Windows Vista
Author oktay_safak
Hi all,

I have kinterbsdb 3.3 + firebird 2.0.6 + Python 2.6 installed on my Vista laptop.

I can import kinterbasdb without problems and verify that it is installed. However, when I try to connect to a firebird database with this setup, I get the following error msg:

Traceback (most recent call last):
File "D:\grid\data_access.py", line 28, in <module>
con = K.connect(dsn=PATH, user=USER, password=PASSWORD)
File "C:\Python26\lib\site-packages\kinterbasdb\__init__.py", line 478, in connect
return Connection(*args, **keywords_args)
File "C:\Python26\lib\site-packages\kinterbasdb\__init__.py", line 641, in __init__
b.dsn, b.dpb, b.dialect, timeout
OperationalError: (-904, 'isc_attach_database: \n unavailable database')

I can connect to the same fdb file using isql anb IBEasy. Also, I can connect to the same database using kinterbsdb 3.3 + firebird 2.0.6 with *Python 2.5*.

Creating a new database through kinterbasdb with Python 2.6 is also impossible, it gives me:

Traceback (most recent call last):
File "D:\grid\data_access1.py", line 10, in <module>
con = K.create_database("create database '%s' user 'sysdba' password 'masterkey'" % PATH)
File "C:\Python26\lib\site-packages\kinterbasdb\__init__.py", line 503, in create_database
C_con = _k.create_database(*args)
ProgrammingError: (-904, 'pyob_create_database: \n unavailable database')

This also works with Python 2.5.

I thought it might be related to file permissions and made sure that the involved dirs and files are readable/writable by all users but the result is the same. I even uninstalled and reinstalled Firebird and kinterbasdb 3.3. but nope. So it really looks like that the problem is in kinterbasdb 3.3 for Python 2.6.

Anybody else having the same problem or is it just me? I would very much appreciate any help.

Thanks in advance.

Oktay