[All]
Error: "Unable to open database. Username & password not defined!"
Abstract: Error: "Unable to open database. Username & password not defined!"
Problem:
I encounter the error of "Unable to open database.
Username & password not defined!" when I enter the
command: "gsec -modify "SYSDBA" -pw '1234' "
Solution:
/*******************************************************************************/
Note: The information in this article applies to
InterBase versions 3.3 and later.
/********************************************************************************/
One way of getting around this error message is to set
the user name and password at the command line with
environment variables.
eg.
type this at the DOS prompt: set isc_user=sysdba
then hit
then type: set isc_password=1234
and hit
Then when you type : gsec -modify sysdba -pw 1234
It will work.
P.S.
You can see that the environment variables have been
set correctly by typing "set" at the command line and hitting
. All of the environment variables for the system
will be printed to the screen.