Helen,

I've tried it both ways, with and without localhost prefixed.


This is the error:

I running this over RemoteDesktop over VPN.

Here is the actual error displayed in the console while running my bat file:

D:\dbRoot\Projects\SqlScripts\Fb\Bat>
"c:\Program Files\firebird\firebird_2_0\bin\isql.exe" -user 'SYSDBA'
-password 'masterkey' -input ..\Create\DbCreate.sql -echo -output
..\OutFile\RecreateDatabase.out.txt
Use CONNECT or CREATE DATABASE to specify a database
Statement failed, SQLCODE = -902
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
After line 0 in file ..\Create\DbCreate.sql

The contents of the script are:

CREATE DATABASE "d:\db\MyDb.fdb"
USER "SYSDBA"
PASSWORD "masterkey";

I've tried this modification:

CREATE DATABASE "localhost:d:\db\MyDb.fdb"
USER "SYSDBA"
PASSWORD "masterkey";

And I've switched to single quotes for both and tried again:


The error is the same.

The same script works fine on a machine on FB 2.01 my local network over
Remote
Desktop.

Any ideas?

Can I simply delete the old FB 1.5 folder and whatever files were left
after the uninstall? or are there some registry issues?

Thanks

Kyle

----- Original Message -----


Subject: Re: [firebird-support] upgrade to 2.01 loses SYSDBA password


From: "Helen Borrie" <helebor@...>


Date: Mon, May 21, 2007 1:54









At 06:44 PM 21/05/2007, you wrote:

>Hi Helen,

>

>This upgrade was on a almost clean machine with only one test database on

>it which I don't care about. So nothing to lose :)

>

>My problem is the default SYSDBA/masterkey won't work in FB 2.01 to create

>a new database.


Is this really the script you are using?


CREATE DATABASE "d:\db\MyDb.
fdb"

USER "SYSDBA" PASSWORD "masterkey";


Try supplying the strings inside single quotes instead of

DQ. Double-quotes have a totally different usage in Dialect 3. You

might get away with DQ around the filespec but you'll need 'SYSDBA'

and 'masterke' for strings that are to be read from a D3 database...


./hb