All geek questions in one place

SQLCODE -904 error in firebird after installation

I first installed the firebird database in my life (version 1.5.6 on Windows 7), after installation I can’t connect to the sample database (employee.fdb) or create the database. This gives the following error in the ISQL tool:

C:\Program Files\Firebird\Firebird_1_5\bin>isql Use CONNECT or CREATE DATABASE to specify a database SQL> CONNECT "C:\Program Files\Firebird\Firebird_1_5\examples\employee.fdb" CON> user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE = -904 unavailable database SQL> create database 'C:\test.fdb' CON> user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE = -904 unavailable database
+4
source share
2 answers

Firebird 1.5 was written (long) before Windows 7 and before things like UAC existed. Perhaps Firebird 1.5 does not work correctly with Windows 7 or requires additional effort to work. I suggest installing Firebird 2.5.2 (Update 1) , since this is the latest version and, as you know, works with Windows 7.

Another problem may be that local system connections do not work, as I seem to remember that Firebird 1.5 uses the old local protocol, which does not work on newer versions of Windows. This protocol has been replaced by Firebird 2.0 . For a workaround to include the host name in the CREATE DATABASE or CONNECT statement, for example:

 create database 'localhost:C:\test.fdb' user 'SYSDBA' password 'masterkey';
+3
source

Windows 7+ splits the local api protocol. You must use the Tcpip protocol to connect to the database, even for local connections.

0
source

Source: https://habr.com/ru/post/1479983/

More articles:


All Articles