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]