Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql code : 904 [DOC55] #62

Closed
firebird-automations opened this issue Dec 27, 2010 · 2 comments
Closed

sql code : 904 [DOC55] #62

firebird-automations opened this issue Dec 27, 2010 · 2 comments

Comments

@firebird-automations
Copy link

Submitted by: Arul Jose. R (aruljose)

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

@firebird-automations
Copy link
Author

Commented by: @paulvink

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.fdb'

If you get a network error, try 127.0.0.1 instead of localhost, or the hostname or IP address of your machine.

If one of these methods works, the local protocol caused the failure. This can often be fixed by opening firebird.conf, uncommenting the IpcName parameter and setting it to Global\FIREBIRD. After this, you must restart the server.

If not, make sure that the server is running. Check Services and/or process list.

Now, if the above information doesn't help you out, please don't reply here but post your problem description to the firebird-support list.
You can subscribe via Yahoogroups or directly by emailing mailto:firebird-support-subscribe@yahoogroups.com (use subject "Subscribe" and leave message body empty).

@firebird-automations
Copy link
Author

Modified by: @paulvink

status: Open [ 1 ] => Closed [ 6 ]

resolution: Won't Fix [ 2 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants