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.