Subject | scripts fail in upgrade |
---|---|
Author | Richard Green |
Post date | 2008-10-02T05:22:39Z |
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
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