I was, in fact, using remote desktop - good one, Helen! Specifying the
hostname solved this problem.

I don't understand why remote desktop causes the problem. Can you
provide some more insight here, so I can explain this when someone
asks me how I fixed it? :)

I thought remote desktop was just opening a terminal window to the
server, but there must be something else going on...

-b

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 07:08 PM 20/04/2005 +0000, you wrote:
>
>
> >Hi all!
> >
> >I have installed Firebird 1.5.2 on a Windows 2003 server machine.
> >
> >When I try to create a database, I get this:
> >
> >C:\Temp>isql
> >Use CONNECT or CREATE DATABASE to specify a database
> >SQL> create database 'fred.fdb' user 'sysdba' password 'masterkey';
> >Statement failed, SQLCODE = -904
> >
> >unavailable database
> >SQL>
> >
> >
> >Any suggestions? The service is started, I've installed

superserver,

> >I
> >have looked for old copies of gds32.dll in the windows\system32
> >directory, and tried everything I can think of.
>
> 1. Have you tried using a path? (Path must exist.)
>
> create database 'c:\data\fred.fdb' user 'sysdba' password

'masterkey';

>
> 2. If you are using Remote Desktop , you'll also need to have

tcp/ip

> running and specify the local hostname, e.g.
>
> create database 'MyServer:c:\data\fred.fdb' user 'sysdba' password

'masterkey';

>
> 3. Make sure that port 3050 is opened in the firewall.
>
> ./hb