Subject Re: [firebird-support] Create database problems, windows server 2003
Author Helen Borrie
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