Subject Re: [firebird-support] Can't Get Started
Author Helen Borrie
At 02:32 AM 13/02/2008, you wrote:
>OK, now I can connect to the employee DB as SYSDBA with password masterkey using IBQ.
>
>(1) However, when I try to create a new DB using ISQL, it tells me that the user (SYSDBA) is not defined and that I should contact my SYS MGR. Something is wrong. Any ideas?

Try doing COMMIT; before you attempt to create (and thus connect to) a new database. Then (assuming Windows):
SQL>SET AUTO ON;
SQL>SET SQLDIALECT 3;
SQL>create database 'localhost:c:\path\to\database\newdb.fdb user 'SYSDBA' password 'xxxxxxxx';

After that you should see a message saying that you are connected to the database. If not, copy the error message exactly and tell us about it.


>(2) After typing in these commands repeatedly and unsuccessfully, how can I run SQL scripts through ISQL?
>IBQ seems to be able to run scripts, but only if you are already connected to a DB. I want to create one.

SQL>INPUT C:\PATH\TO\MYSCRIPT.SQL;

>Can someone please point me to the documentation on this?

If you don't own a book on the subject ;-) then you can use the IB 6 beta Language Reference for the syntax.

If you do: study Part Four (Chapters 14 & 15 especially: pp.220 ff. are all about scripts).

./heLen