isql ignores username and password arguments if a -x or a -a is also passed as an arg.

By: Quinn Wildman

Abstract: To specify the user name and password when using -a or -x you must use ISC_USER and ISC_PASSWORD

isql ignores username and password arguments if a -x or a -a is also passed as an arg.

Example:

isql server:c:diremployee.gdb -x -user sysdba -password masterkey

generates the error:

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

If you have physical access to the database, or the ISC_USER and ISC_PASSWORD environmental variables are set then isql will not generate an error. For more information on the ISC_USER and ISC_PASSWORD environment variables see chapter 3 of the API Guide.

Server Response from: ETNASC04