After installing firebird on my server i cant get it to run well as an service, the service is started, but i cant connect to any database, i get with gsec the following error: unavailable database, and with ibexpert it gives me an error that it cant attach to an unaivalable resource.
But when i run it in application mode it all works fine. When i look at the applet in control panel, it says the service is started, but there's a red cross through the logo.
tried 1.03, 1.5 (classic and superserver) same problem on all. This is on a windows 2000 server.
Thanks in advance,
Martin
Originally posted by WooTz
After installing firebird on my server i cant get it to run well as an service, the service is started, but i cant connect to any database, i get with gsec the following error: unavailable database, and with ibexpert it gives me an error that it cant attach to an unaivalable resource.
But when i run it in application mode it all works fine. When i look at the applet in control panel, it says the service is started, but there's a red cross through the logo.
tried 1.03, 1.5 (classic and superserver) same problem on all. This is on a windows 2000 server.
Thanks in advance,
Martin
I think it's not registered well as service . You have to remove firebird as a service (instsvc is in firebird bin dir) Open a Dos console and
At the command prompt, type:
instsvc remove -z
Remove the firebird sub-key from the NT Registry. At the command prompt, type:
instreg remove -z
Install the new version.
Here are some old instructions (for interbase) but it should work for firebird too
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='10'
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='139'
well i did that before, tried reinstalling, didnt work, already with a fresh install (i had never used firebird before on the server) it wouldnt work, keep getting the same error
the service is running but i just cant use it, only when it runs in application mode.
Originally posted by WooTz
well i did that before, tried reinstalling, didnt work, already with a fresh install (i had never used firebird before on the server) it wouldnt work, keep getting the same error
the service is running but i just cant use it, only when it runs in application mode.
What errors do you see in the firebird logs ? and
take a look in the Event Viewer (windows logs)
this is from event log:
The description for Event ID ( 251 ) in Source ( Firebird Guardian ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Server Started: Guardian starting: D:\Firebird\bin\ibserver.exeROCESSOR_REVISION=0204.
firebird log just says it got started normally.
Originally posted by WooTz
this is from event log:
The description for Event ID ( 251 ) in Source ( Firebird Guardian ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Server Started: Guardian starting: D:\Firebird\bin\ibserver.exeROCESSOR_REVISION=0204.
firebird log just says it got started normally.
First let's start the guardian , You have to run
the regedit.exe (Start->Run) and modify the
FirebirdGuardian key to point to the fbguard
My Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FirebirdGuardian\ImagePath
Here is a screenshot with the key you have to modify
well the services are started already, as well the keys on my machine are still named InterbaseGuarding etc... but the services ARE started, i just cant use them with gsec, or any other program.
Originally posted by WooTz
well the services are started already, as well the keys on my machine are still named InterbaseGuarding etc... but the services ARE started, i just cant use them with gsec, or any other program.
Hmmm...
Ok search for the gds32.dll on the system and tell
me what version of the dll and server do you have (Firebid 1.5 rc3 Super Server?) .
Do you have some firewall there ?
Have you tried to connect from the command line with the isql ?
yes it runs and all, like i said the services are started, it just cant find its databases, prolly cuz i installed it through terminal server, cuz it works fine in application mode.
I am having the exact same problems. I installed Firebird 1.5 through term serv and I am getting unavailable resource errors and unavailable database errors.
I have installed Firebird on another w2k machine through term serv and it worked fine but this one is choking.
I had to add localhost: to the database path when accessing the database through term serv. I didn't have to do this on another machine when I was using term serv, however. Must have something to do with how term serv is configured.
Anyway, adding the localhost: fixed the error and things are working great.
I know this is an old thread, but just in case anyone is still having problems with this. I had exactly the same thing with the old interbase 5.6 on a winxp machine. Worked fine as an app, but nothing would connect when it ran as a service - regardless of whether it was running as system or the user I was signed on as.
I ended up disabling the service thinking it was useless. A couple of days later when I wanted to see if I could get to the bottom of it I reenabled and started the service and it works fine. So I'd suggest disabling the service and rebooting then reenabling it and seeing if this fixes the problem.
Dear all
I also run the firebird through the TS environment, but I don't have that problem.
You just create new user to start the firebird service, don't use the same user id as you login, otherwise you will get the unavailable resource error....^_^
holp that help.... :)
I have been having the exact same problem, as of late. Tried uninstalling Firebird and re-installing, sometimes along with FB-Guardian, sometimes without. Sometimes as a service, sometimes as an application. All of them resulted with the "unavailable resource - unavailable database" message.
But Quinnh's suggestion of adding localhost to the database path worked for me perfectly. I used IB-Expert to manage remote databases (and some local ones too). I added "localhost:" to the database path, and it worked. When I looked back at the connection settings again, I saw that it had changed its server setting to "Remote", and servername to "localhost". Don't know how this actually changes squat, but it's a relief its working... at least for now.