Subject | RE: [firebird-support] scripts fail in upgrade |
---|---|
Author | Richard Green |
Post date | 2008-10-02T22:07:17Z |
Helen and all,
I'm logged in directly as Administrator, sitting at the console. I've tried all these variations with single and doulble quotes with hosts and no hosts. The errors are identical.
These scripts work on 6 other servers via RDT (windows 2003), but only with Firebird 1.5, but not Firebird 2.0. I have literally hundreds of scripts.
FlameRobin accepts SYSDBA/masterkey, so it seems that they are valid.
I tried these variations:
CREATE DATABASE "d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER "SYSDBA" PASSWORD "masterkey";
CREATE DATABASE "d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER 'SYSDBA' PASSWORD 'masterkey';
CREATE DATABASE "MyServer:d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER 'SYSDBA' PASSWORD 'masterkey';
CREATE DATABASE "localhost:d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER "SYSDBA" PASSWORD "masterkey";
CREATE DATABASE "localhost:d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER 'SYSDBA' PASSWORD 'masterkey';
Thanks,
Kyle
I'm logged in directly as Administrator, sitting at the console. I've tried all these variations with single and doulble quotes with hosts and no hosts. The errors are identical.
These scripts work on 6 other servers via RDT (windows 2003), but only with Firebird 1.5, but not Firebird 2.0. I have literally hundreds of scripts.
FlameRobin accepts SYSDBA/masterkey, so it seems that they are valid.
I tried these variations:
CREATE DATABASE "d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER "SYSDBA" PASSWORD "masterkey";
CREATE DATABASE "d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER 'SYSDBA' PASSWORD 'masterkey';
CREATE DATABASE "MyServer:d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER 'SYSDBA' PASSWORD 'masterkey';
CREATE DATABASE "localhost:d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER "SYSDBA" PASSWORD "masterkey";
CREATE DATABASE "localhost:d:\db\fb\Data\TmpltSiteDb\TmpltSiteDb.fdb" USER 'SYSDBA' PASSWORD 'masterkey';
Thanks,
Kyle
----- Original Message -----
From: helebor@...
Sent: Thu, October 2, 2008 14:54
Subject: RE: [firebird-support] scripts fail in upgrade
At 07:18 3/10/2008, you wrote:
[Non-text portions of this message have been removed]