Interbase Error 904
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error SQLCODE -904 in firebird after installation up vote 4 down vote favorite 1 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 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 firebird1.5 share|improve this question asked May 9 '13 at 19:57 BartÅ‚omiej Pach 91313 If it is the first time, why do you install an old 1.5 version, instead of the latest 2.5.2? –Mark Rotteveel May 10 '13 at 6:48 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted 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 Firebird 2.5.2 (update 1) 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 Firebird 2.0. 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'; share|improve this answer answered May 10 '13 at 6:53 Mark Rotteveel 36.3k84677 add a comment| up vote 0 down vote Windows 7+ breaks the local api protocol. You have to use Tcpip protocol to connect to the datab
1.5 installed. i have the followwing code return on service startup with FIBDatabase1 do begin Connected:=false; log(database_path); DatabaseName:='e:\Projects\MyDB.gdb'; http://stackoverflow.com/questions/16470071/error-sqlcode-904-in-firebird-after-installation Params.Clear; Params.Add('user_name=SYSDBA'); Params.Add('password=masterkey'); LoginPrompt:=false; Connected:=true; end; It says "Unavailable Database SQL code-904" But this same code works fine if i tried to connect on a sample application on http://www.delphipages.com/forum/archive/index.php/t-177056.html button click. What could be the reason for this problem? Regards, Shanand Chandradas. autocorect12-28-2006, 02:59 AMTry to see if the component it's created when you call connected=true ; put code in Form.OnShow an see if it's ok. shanandc12-28-2006, 03:06 AMJust tell me what does that error message mean? Does it require anything before service is started? Thanks for your time Regards, Shanand autocorect12-28-2006, 05:09 AMI use the google and find this: http://forums.devshed.com/firebird-sql-development-61/unavailable-database-327929.html http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.dshare/bjnzmstr55.htm http://search.archivesat.com/cgi-bin/search.cgi?a=search&q=904&tag=1636 vBulletin v3.8.8, Copyright ©2000-2016, vBulletin Solutions, Inc.
Arul Jose. R Votes: 0 Watchers: 0 Operations If you were logged in http://tracker.firebirdsql.org/browse/DOC-55 you would be able to see more operations. Documentation sql http://www.delphigroups.info/2/7/755454.html code : 904 Created: 27/Dec/10 03:44 PM Updated: 28/Dec/10 11:27 PM Component/s: None Affects Version/s: None Fix Version/s: None Environment: Windows XP Description « Hide My firebird installation is throwing 904 sql code. Could not find any description for interbase error this in firebird documentation. What does this SQL code mean? C:\arul\firebird\Firebird-2.1.3.18185-0_Win32\bin>isql -u SYSDBA -p masterkey Use CONNECT or CREATE DATABASE to specify a database SQL> CREATE DATABASE 'c:\arul\firebird\utftester1.fdb' user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE = -904 unavailable database C:\arul\firebird\Firebird-2.1.3.18185-0_Win32\bin>fbserver.exe C:\arul\firebird\Firebird-2.1.3.18185-0_Win32\bin>isql -u SYSDBA -p masterkey ..\security2.fdb Statement failed, SQLCODE = interbase error 904 -904 unavailable database Use CONNECT or CREATE DATABASE to specify a database Description My firebird installation is throwing 904 sql code. Could not find any description for this in firebird documentation. What does this SQL code mean? C:\arul\firebird\Firebird-2.1.3.18185-0_Win32\bin>isql -u SYSDBA -p masterkey Use CONNECT or CREATE DATABASE to specify a database SQL> CREATE DATABASE 'c:\arul\firebird\utftester1.fdb' user 'SYSDBA' password 'masterkey'; Statement failed, SQLCODE = -904 unavailable database C:\arul\firebird\Firebird-2.1.3.18185-0_Win32\bin>fbserver.exe C:\arul\firebird\Firebird-2.1.3.18185-0_Win32\bin>isql -u SYSDBA -p masterkey ..\security2.fdb Statement failed, SQLCODE = -904 unavailable database Use CONNECT or CREATE DATABASE to specify a database Show » All Comments Change History Version Control Subversion Commits Sort Order: [ Permalink | « Hide ] Paul Vinkenoog added a comment - 28/Dec/10 11:26 PM First, please do not use the Tracker for support questions! As for your problem: either the server isn't running or the local protocol isn't working correctly. Try creating 'localhost:c:\arul\firebird\utftester1
PM delphi200 Hi, I am having a DOS batch file containing a call to isql (ver 4.1) which is working fine if it is started manually from the command line or Win Explorer BUT if I schedule this batch file thru Win2000 scheduler or run it thru the telnet session from a remote computer I get error: "Statement failed, SQLCODE = -904" and "unavailable database". InterBase server is certainly running on the IB server / telnet host machine. Any ideas ? Thanks 1. Writing a commerical IDE in D7.2. Administrative Package of Delphi 20053. Group Commit Vs. Forced Writes4. help me. help my "ActiveX Document Server" by delphi 6...5. Tag data component for M4A / AAC music files?1. Any truth in this one?2. Repost : Old thread on ADO Connection error3. Query and error4. Which DB components to keep compatibility (D7 -D8)5. Detecting project/unit creation or when Save will do a SaveAs