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
Post a Comment