Subject RE: [firebird-support] scripts fail in upgrade
Author Richard Green
looks like parts of my messages are being stripped., the bat file command did not show.

This is the error I get when the create statement below is run in an sql file, executed from a bat file.

Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.


The SYSDBA account exists, and I can use it in FlameRobin.

Thanks for any help.




----- Original Message -----
From: kyleblm@...
Sent: Fri, October 3, 2008 22:57
Subject: RE: [firebird-support] scripts fail in upgrade




















This problem persists, and is becoming a showstopper.



Is anyone able to run an sql script file like this, from a bat file, with Firebird 2.x?



CREATE DATABASE 'localhost:d:\db\fb\Data\TmpltDb\TmpltDb.fdb'

USER 'SYSDBA'

PASSWORD 'masterkey';



It seems simple. Can I assume that since I can use FlameRobin to access databases on this machine, using the above login/password, that the login and password are valid?



The bat file command looks like this:



D:\Bat



[Non-text portions of this message have been removed]



































[Non-text portions of this message have been removed]