firebird1.5 - Error SQLCODE -904 in firebird after installation -


i installed firebird database first time in life (version 1.5.6 on windows 7), after installation can not connect sample database (employee.fdb exists), or create database. gives following error in isql tool:

c:\program files\firebird\firebird_1_5\bin>isql use connect or create database specify 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 

firebird 1.5 written (long) before windows 7, , before things uac existed. may firebird 1.5 doesn't work correctly windows 7, or requires additional effort work. i'd suggest install firebird 2.5.2 (update 1) latest version , known work windows 7.

another problem might local system connections don't work seem remember firebird 1.5 uses older local protocol doesn't work on newer windows versions. protocol replaced in firebird 2.0. workaround need include hostname in create database or connect statement, example:

create database 'localhost:c:\test.fdb' user 'sysdba' password 'masterkey'; 

Comments

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

c++ - qgraphicsview horizontal scrolling always has a vertical delta -