(I am new in firebird). It did work after I prefix the IP address,
Thanks.
SQL> create database '127.0.0.1:bbb.fda';
Commit current transaction (y/n)?y
Committing.
SQL> commit;


Is there any way I can set the server to not requiring prefixing the
IP address? As it works in most of machines, we put that in the build
script without the prefix. I need to fix this problem in my
development environment.

I am using Firebird 1.5.1 (Win32 Build)
in windows server 2003.


Thanks again.
Elwin


--- In firebird-support@yahoogroups.com, "Sławek Cabaj"
<scabaj@...> wrote:

>
> All these experimentations I do on my own comp, Win XP system,home

edition; the same situation there is on XP prof edition with service
pack 3 (second comp) only error messages are diffrent ; with gsec I
get "Your user name and password are not defined..."; with isql "Use
CONNECT or CREATE DATABASE to specify database" When I try from
administrator account it works perfectly. When switched on test
account withount administrator privileges fails. The test database
and Firebird are on the same computer. Server - Firebird 2.0,
superserver; default installation; everything do from focal shell;

>
>
> Helen Borrie <helebor@...> wrote: At

01:10 AM 3/10/2007, you wrote:

> >I'm trying to use gsec and isql from command line window (cmd);
> > when I run "gsec -user SYSDBA -password masterkey" I

get "Cannot

> > attach to services manager; unable to open database"
>
> It appears that your command shell client is a remote desktop
> client. If so, you need to include the -database switch and

provide

> the full network address of the security database, e.g., for Fb 2:
>
> gsec -database ourserver:c:\Program
> Files\Firebird\Firebird_2_0\security2.fdb -user sysdba -password

masterkey

>
> >when I run 'isql "C:\Data\DB.FDB" -user SYSDBA -password

masterkey'

> > I get
> > Statement failed, SQLCODE = -904
> >unavailable database
> >Use CONNECT or CREATE DATABASE to specify a database
>
> Similar solution - a remote desktop client needs to supply the

full

> network path to the database. For isql there is no special switch.
>
> 'isql "ourserver:C:\Data\DB.FDB" -user SYSDBA -password masterkey'
>
> > From administrator account there is no problem.
>
> Your administrator account runs in a local shell?
>
> There are other possible explanations for your problems but you
> haven't provided any information about server version (that means

the

> numbers after the word "Firebird" on the kit you installed), model
> (Superserver/Classic/Embedded) or the version of Windows you are

running.

>
> ./heLen
>
>
>
>
>
> ---------------------------------
> Don't let your dream ride pass you by. Make it a reality with

Yahoo! Autos.

>
> [Non-text portions of this message have been removed]
>