|Subject||RE: [firebird-support] 2.01 no default SYSDBA|
> Hello,have you tried not putting single quotes around the username and password?
> I am still pursuing this problem on a WIndows 2003 server.
> I removed all evidence of a previous FB 1.5 install
> I had previously uninstalled, but now I have deleted the remaining
> Firebird_1_5 folder.
> I also uninstalled 2.01, and deleted its folder.
> Next I reinstalled 2.01, and everything looked normal. When I run my
> standard create database script via a bat file:
> CREATE DATABASE 'd:\db\fb\Data\MyDb\MyDb.fdb' USER 'SYSDBA' PASSWORD
> I get an error that the account does not exist:
> "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
> Is this a bogus error message? Is there some other problem?
> I am running the bat file and script over VPN and Remote Desktop.
> This is obvioulsy a showstopper. It was a normal straightforward install
> as far as I can tell.