Connecting to a Firebird 5 fdb file from LibreOffice 26.2 on Windows 10

English
#1

Can anyone please help on using both LO and isql to build, maintain and use a Firebird 5 database?

In my firebird.conf file I have the following aliases
locdb = C:/Users/salis/Documents/DBs/TestDB/LOCREATEDDB.FDB # (Created by LO)
teste = C:/Users/salis/Documents/DBs/TestDB/teste.fdb # (Created by isql)

If I try to connect to the isql-created database from LO I get
Error code: 1

firebird_sdbc error:
*unsupported on-disk structure for file C:\USERS\SALIS\DOCUMENTS\DBS\TESTDB\TESTE.FDB; found 13.1, support 12.2
caused by
‘isc_attach_database’

If I try to use isql to update a database created by LO (using the information in Firebird Connection) I get
CONNECT locdb user ‘fbbatch’ password ‘fbbatch’;
Statement failed, SQLSTATE = HY000
unsupported on-disk structure for file locdb; found 12.0, support 13.1

It looks at though there is some incompatibility between the two ways to access the same Firebird database?

Is there an explanation and fix for this?

Thank you.

#2

The internal driver of LO supports only Firebird3. So you couldn’t connect to Firebird5 with this driver.
.
Only possibility to connect to Firebird5 is to use JDBC or ODBC-connection. So you could connect to the Firebird file through a Firebird server.

#3

:grey_question:
V_Firebird

#4

Thank you for your information.

It was because I was having problems with a JDBC/ODBC route that I went down this more-direct approach - which won’t work.

I’ll keep going on the JDBC/ODBC route.

Regards

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.