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

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:

"c:\Program Files\firebird\firebird_2_0\bin\isql.exe" -user 'SYSDBA'
-password 'masterkey' -input ..\Create\DbCreate.sql -echo -output
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"
PASSWORD "masterkey";

I've tried this modification:

CREATE DATABASE "localhost:d:\db\MyDb.fdb"
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

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?



----- 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?



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...