If this is another machine you need to define ISC_USERNAME and ISC_PASSWORD …see environment variables on old machine!



Regards,
Paul



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Richard Green
Sent: Thursday, October 02, 2008 08:23
To: firebird-support@yahoogroups.com
Subject: [firebird-support] scripts fail in upgrade



Hello,

I have a whole set of scripts that work with Firebird 1.5, but are not
working on Firebird 2.1.

I have a bat file that calls an sql file.

This is the bat file contents where %SqlExe% is the path to isql.exe,
using SYSDBA and masterkey:

%SqlExe% -user %Usr% -password %Pwd% -input ..\Create\DbCreate.sql -echo
-output %OutFile%

DbCreate.sql has only this:

CREATE DATABASE "localhost:d:\db\fb\Data\TmpltDb\TmpltDb.fdb"
USER "SYSDBA"
PASSWORD "masterkey";

or

CREATE DATABASE "d:\db\fb\Data\TmpltDb\TmpltDb.fdb"
USER "SYSDBA"
PASSWORD "masterkey";

The script fails with firebird 2.1. Ive tried it with single quotes as
well as double quotes.

SqlState = 28000
Your user name or password are not defined

The exact same scripts work on Windows Server 2003 with Firebird 1.5.

What do I need to do?

Thanks,
Kyle





[Non-text portions of this message have been removed]