Stack Overflow
Stack Overflow

Questions tagged [kinterbasdb]

KInterbasDB is a Python extension package that implements Python Database API 2.0-compliant support for Firebird and some versions of Borland® Interbase®

KInterbasDB is a Python extension package that implements Python Database API 2.0-compliant support for the open source relational database Firebird and some versions of its proprietary cousin Borland® Interbase®. In addition to the minimal feature set of the standard Python DB API, KInterbasDB also exposes nearly the entire native client API of the database engine.

The package is free--covered by a permissive BSD-style license that both commercial and noncommercial users should find agreeable.

Site: http://kinterbasdb.sourceforge.net/

Download: https://sourceforge.net/projects/kinterbasdb/

Development of this library ended a long time ago. Newer libraries are:

13 questions
12
votes
3 answers

How do I get a list of tables from a Firebird database?

So I've got a couple of Firebird databases I need to convert. I've managed to connect to them using python code and the kinterbasdb library, but I can't find a way to get a list of all the tables in the database. Is there a command that will give me…
Beacon80
  • 349
  • 1
  • 4
  • 14
2
votes
2 answers

Creating named tuple from tuple?

I'm working with kinterbasdb to select and update some data from databases of 1998 (yes, unfortunatly :(). And the API of kinterbasdb return the values from queries in tuples, for example: connection = connect(dsn="database.gdb", user="MYUSER",…
user7427352
2
votes
1 answer

importing cx_Oracle and kinterbasdb returns error

Greetings, everybody. I'm trying to import the following libraries in python: cx_Oracle and kinterbasdb. But, when I try, I get a very similar message error. *for cx_Oracle: Traceback (most recent call last): File "", line 1, in ImportError: DLL…
Dante
  • 21
  • 2
1
vote
1 answer

Using kinterbasdb with py2exe

I'm trying to create executable program with py2exe. I get the following error message when kinterbasdb is imported: Traceback (most recent call last): File "AlarmReporter.py", line 13, in File "zipextimporter.pyo", line 82, in…
Harriv
  • 6,029
  • 6
  • 44
  • 76
1
vote
1 answer

How to run DDL script with kinterbasdb

Is there way to execute DDL script from Python with kinterbasdb library for Firebird database? Basically I'd like to replicate 'isql -i myscript.sql' command.
Harriv
  • 6,029
  • 6
  • 44
  • 76
1
vote
2 answers

Firebird versions and returning value

I am trying to use kinterbasdb and Python 2.7 to write data to a Firebird database on a server, and print the key value of the added data. It works perfectly when I write to a local copy of the database. insert = """INSERT INTO myTable…
lemmyBarnet
  • 59
  • 1
  • 8
1
vote
2 answers

Get first item of returning function value

I'm working with kinterbasdb module, and the module has this function called fetchone, that returns the result of an execution of a query: cursor.execute("....") cursor.fetchone() This returns a tuple: ("value1",), and i want access the first item,…
user7427352
1
vote
2 answers

Opening a GDB database

I've been tasked with creating a script to convert Firebird databases to SQL. I was given to example files, one is a .FDB and one is a .GDB. Using the kinterbasdb library and Firebird Guardian 2.0, I was able to connect the the FDB file, but if I…
Beacon80
  • 349
  • 1
  • 4
  • 14
1
vote
1 answer

SQLAlchemy and kinterbasdb in separate apps under mod_wsgi

I'm trying to develop an app using turbogears and sqlalchemy. There is already an existing app using kinterbasdb directly under mod_wsgi on the same server. When both apps are used, neither seems to recognize that kinterbasdb is already…
user16401
  • 31
  • 2
0
votes
1 answer

what is the best way to sync SQL Server with Interbase database?

I need to sync SQL server database with the Interbase DB. Interbase is the live DB and main application works on this. Now customer wants to cerate an SQL server database and sync it with the live interbase database once everyday. All historical…
Chacko
  • 1
0
votes
0 answers

Select from python is retrieving wrong form

I'm working with the Firebird database, and I would like to know how to fix a format from an SELECT query. The SELECT query is returning this from the isql NU_INSCRICAO ======================= 4228949000102.000 But in my software,…
user6739366
0
votes
1 answer

python kinterbasdb - different encoding for varchar and blob

I have table with USER VARCHAR(100) CHARACTER SET WIN1250, NOTE BLOB SUB_TYPE 1 CHARACTER SET WIN1250, But when I pick up data from this table with kinterbasdb in python 2.7 (# -- coding: utf-8 --) VARCHAR field is ok but BLOB field seems to be…
peter
  • 4,289
  • 12
  • 44
  • 67
-6
votes
1 answer

Error in sql request

I wrote this program: con=kinterbasdb.create_database("create database 'D:/ThirdTask/test.db' user 'sysdba' password 'masterkey'") conn=kinterbasdb.connect(host='localhost',database='D:/ThirdTask/test.db', user='sysdba',…
dva
  • 47
  • 1
  • 1
  • 6