Error: "Unable to open database. Username & password not defined!"

By: Borland Staff

Abstract: I encounter the error of "Unable to open database. Username & password not defined!" when I enter the command: "gsec -modify "SYSDBA" -pw '1234' "

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.

Server Response from: ETNASC03