Adam and all,

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";


The error is the same.


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

Any ideas?


Thanks

Kyle

----- Original Message -----
Subject: [firebird-support] Re: upgrade to 2.01 loses SYSDBA password
From: "Adam" <s3057043@...>
Date: Sat, May 19, 2007 22:37







--- In firebird-support@
yahoogroups.
com, "Kyle Green" <kyleblm@...
> wrote:

>

> Hello,

>

> I've upgraded Fb 1.5 to 2.01 on a non-critical Windows 2003 machine that

> had one previous database. (I uninstalled 1.5 first)

>

> I'm trying to run a script file with a simple create database

command and

> I get an error.

>

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

> USER "SYSDBA"

> PASSWORD "masterkey";

>

> Your user name and password are not defined. etc

>

>

> What might have gone wrong, how can I fix?


Are you connected through terminal services? If so, either put

'localhost:' before the database path or set the Global IPC in

firebird.conf.


Adam