That is close, but isn't quite right...

The knowledge base article refers to the message :
unable to open database
your user name and password are not defined......

but, the message I am actually getting is:
unavailable database
unable to open database

If I supply the database, userid, and password on the gsec command line, I can connect.

-bill

-----Original Message-----
From: Muthu Annamalai [mailto:pearlamerica@...]
Sent: Tuesday, January 13, 2004 11:42 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] gsec - unavailable database


Hi,

Refer the link

http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1074015184:100180&l=;IBPHOENIX.KNOWLEDGEBASE;ID='106'

Muthu Annamalai

----- Original Message -----
From: Bill Oliver
To: firebird-support@yahoogroups.com
Sent: Tuesday, January 13, 2004 10:36 AM
Subject: [firebird-support] gsec - unavailable database


Hello,

When I try to run gsec, I get the "unavailable database" message, see example below. Evidently firebird can't find the security.fdb file. When I specify the database on the command line, gsec works. I also can't connect using ISQL - I get the same message.

I am running 1.5 RC8 on Windows 2000 Server SP3. I have this working on another (Windows XP) machine, so I am stumped.

Thanks in advance for any help.



C:\firebird1.5\bin>gsec -user sysdba -password masterkey
unavailable database unable to open database

C:\firebird1.5\bin>
C:\firebird1.5\bin>
C:\firebird1.5\bin>gsec -database endure2:\firebird1.5\security.fdb -user sysdba -password masterkey
GSEC> quit

C:\firebird1.5\bin>

-bill

Bill Oliver
Product Specialist, Base SAS
SAS Institute - The Power To Know
bill.oliver@...
919-531-0675




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




------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
---------------------------------------------------------------------~->

Yahoo! Groups Links

To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to: firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/