Opening a GDB database

Question

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 try the same code with the GDB file, I get an error message.

Code:

filename = r'C:\TEMP\TEST_DB.GDB'

user = 'sysdba'

password = 'masterkey

con = kinterbasdb.connect(dsn=filename, user=user, password=password)

Results:

kinterbasdb.OperationalError: (-820, 'isc_attach_database: \n unsupported on-disk structure for file C:\TEMP\TEST_DB.GDB; found 11.1, support 11.0')

Any advice would be helpful.

score 2 · Accepted Answer · answered Feb 19 '14 at 21:12

Your database has an On-Disk Structure (ODS) version 11.1, but your Firebird version only supports ODS 11.0 or lower. ODS 11.0 is Firebird 2, ODS 11.1 is Firebird 2.1 and ODS 11.2 is Firebird 2.5.

You will need to install Firebird 2.1 or higher (I'd advise to use Firebird 2.5).

Edgard Leal · Answer 2 · 2014-02-19T22:12:17.180

-2

-820, 'isc_attach_database error may be :

The version of the database file is larger than the library version.

The database file is corrupted. ( see this link: repair a corrupt database )

ibexpert documentation

firebird documentation

edited Feb 19 '14 at 22:12

answered Feb 19 '14 at 21:35

Edgard Leal

2,592
26
30

-820 is an error **group** that prevented connection. This specific errorcode simply means the database is not supported by the Firebird version. – Mark Rotteveel Feb 19 '14 at 21:45
Read the documentation before giving a negative vote – Edgard Leal Feb 19 '14 at 22:13
I know the cause of this error, and it isn't corruption of the file, hence my downvote. – Mark Rotteveel Feb 20 '14 at 08:34

Opening a GDB database

2 Answers2