Hello Community, we have an ERP software that is based on a Firebird 2.1 Server. With the help on the ODBC driver, I read data from the DB into Excel a Token unknown - ODBC firebird driverfirebirddynamic sql error.
I installed firebird database for the first time in my life (version 1.5.6 on Windows 7), after installation I can not connect to the sample database (employee.fdb exists), or create a database. This gives the following error in ISQL Tool: C:Program FilesFirebirdFirebird15binisqlUse CONNECT or CREATE DATABASE to specify a databaseSQL CONNECT 'C:Program FilesFirebirdFirebird15examplesemployee.fdb'CON user 'SYSDBA' password 'masterkey';Statement failed, SQLCODE = -904unavailable databaseSQL create database 'C:test.fdb'CON user 'SYSDBA' password 'masterkey';Statement failed, SQLCODE = -904unavailable database.
Firebird 1.5 was written (long) before Windows 7, and before things like UAC existed. It may simply be that Firebird 1.5 doesn't work correctly with Windows 7, or that it requires additional effort to work. I'd suggest to install as that is the latest version and is known to work with Windows 7.Another problem might be that local system connections don't work as I seem to remember that Firebird 1.5 uses an older local protocol which doesn't work on newer Windows versions.
This protocol was replaced in. To workaround that you need to include the hostname in the CREATE DATABASE or CONNECT statement, so for example: create database 'localhost:C:test.fdb' user 'SYSDBA' password 'masterkey'.
I'm trying to make DBeaver database manager connect to a Firebird.FDB file. It is a local file database and I want to inspect the tables etc and perform some queries for data reporting.However, when I try to open the database in DBeaver I get this error message:Unable to complete network request to host'localhost'.SQLState:08006, ISC error code 335544721Connection refused: connectI've tried updating the driver, which updates the org.firebirdsql.jdbc:jaybird-jdk18:RELEASE 3.0.5 without any errors, and also enabling/disabling the embedded checkbox.As far as I know Firebird is supported by DBeaver, what am I doing wrong here? After some trial and error I've figured out the answer to this. The services Firebird Service and Firebird Guardian weren't running. I had installed the Firebird Server but accidentally selected 'Run as an Application' instead of 'Run as a Service'.DBeaver cannot connect to the Firebird database file without these services running.
Which is kind of odd because the osFinancials application that uses this database file was working just fine without the services.Anyway, once the Firebird Server is installed as 'run as application' there is AFAIK no easy way to still get it to run as a service. So I just uninstalled and then reinstalled the Firebird Server setup and selected the correct option.It adds two services named FirebirdGuardianDefaultInstance and FirebirdServerDefaultInstance which correspond to these two commandlines: 'C:Program Files (x86)FirebirdFirebird25binfbguard.exe' -s DefaultInstance'C:Program Files (x86)FirebirdFirebird25binfbserver.exe' -s DefaultInstance.