community.borland.com

Article #25362: Setting the ISC_USER and ISC_PASSWORD environment variables

Problem:
When the command line utilities are run it gives the error: 

      Your user name and password are not defined.  Ask your 
      database administrator to setup an InterBase login.


Solution:
The information in this article applies to:
 * InterBase 4.x
 * InterBase 5.x

You need to set the environment variables for ISC_USER and ISC_PASSWORD, or specify the user name and password on the command line for the command line utility.

To set the environmental variables it can be accomplished in 2 different ways:

1) For an individual DOS session use the SET command:

SET ISC_USER=SYSDBA (carriage return)
SET ISC_PASSWORD=masterkey (carriage return)

2) To set the system environment variables (globally)
   a. For Windows 95
        You can set the variables for a shortcut to a DOS session by right clicking the shortcut icon and
        selecting properties. Check the 'MS-DOS mode' and 'Specify a new MS-DOS configuration' 
        boxes. Enter the above SET commands in the Autoexec.bat window.

        Or you can edit the Autoexec.bat file in the root directory to set these variables for all DOS 
        sessions.	

   b. For Windows NT
        You can set the environment variables for a shortcut to a DOS session as above for Windows 95.
        
        To set them globally:
        In the Control Panel double click the 'System' icon. Go to the 'Environment' tab and click in the
        System window (the top one). Then enter ISC_USER in the 'Variable' field and SYSDBA in the
        'Value' field. Click the 'Set' button.  Repeat for ISC_PASSWORD using masterkey for the value. 


Last Modified: 18-OCT-00