Subject Re: [firebird-support] firebird 1.5 losing default hostname or something ...
Author Helen Borrie
At 03:05 AM 28/05/2004 +0000, you wrote:
>Hi,
>
>I have 1.5 installed on a w2k server. I've had 1.0.3 working fine
>previously on this box. I've uninstalled, reinstalled etc etc.
>
>Problem seems to be that the applications can't find the local machine
>by default.
>
>So I've done this after unzipping latest download (also tried the
>setup.exe deal):
>
>C:\Program Files\Firebird\Firebird_1_5\bin>install_super.bat
>
>C:\Program Files\Firebird\Firebird_1_5\bin>instreg install -z
>instreg version WI-V1.5.0.4290 Firebird 1.5
>Firebird has been successfully installed in the registry.
>
>C:\Program Files\Firebird\Firebird_1_5\bin>instsvc install -auto
>-superserver -guardian -z
>instsvc version WI-V1.5.0.4290 Firebird 1.5
>
>C:\Program Files\Firebird\Firebird_1_5\bin>instsvc start
>Service "Firebird Guardian - DefaultInstance" successfully started.
>
>
>Then I do this:
>
>C:\Program Files\Firebird\Firebird_1_5\bin>gsec
>unavailable database
>unable to open database
>
>But if I do this:
>
>C:\Program Files\Firebird\Firebird_1_5\bin>gsec -database
>"localhost:c:\program files\firebird\firebird_1_5\security.fdb" -user
>sysdba -password masterkey
>GSEC>
>
>I get in, and can add a user without problems:
>
>GSEC> add chris -pw pwd
>GSEC> display
> user name uid gid full name
>--------------------------------------------------------------------------------
>SYSDBA 0 0
>CHRIS 0 0
>GSEC> quit
>
>
>Then I next have the following problem:
>
>C:\Program Files\Firebird\Firebird_1_5\bin>isql
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> CREATE DATABASE "C:\firebird\test.fdb" user "chris" password "pwd";
>Statement failed, SQLCODE = -904
>
>unavailable database
>SQL>
>
>And once again can only create or connect to databases with a fully
>qualified path.
>
>SQL> CREATE DATABASE "localhost:C:\firebird\test.fdb" user "chris"
>password "pwd";
>SQL>
>
>So obviously something isn't set right in the networking of my w2k
>box, although ping and nslookup work fine. Anyone have any ideas?

Yes: it looks as though you have installed the Classic version. If you've
been doing things as you described, you've no doubt got a mish-mash of
stuff on the hard-disk now. Check your Services applet to see what you're
actually running.

/heLen