Subject | Re: [firebird-support] Can't Get Started |
---|---|
Author | Helen Borrie |
Post date | 2008-02-13T04:53:35Z |
At 02:32 AM 13/02/2008, you wrote:
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.
If you do: study Part Four (Chapters 14 & 15 especially: pp.220 ff. are all about scripts).
./heLen
>OK, now I can connect to the employee DB as SYSDBA with password masterkey using IBQ.Try doing COMMIT; before you attempt to create (and thus connect to) a new database. Then (assuming Windows):
>
>(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?
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?SQL>INPUT C:\PATH\TO\MYSCRIPT.SQL;
>IBQ seems to be able to run scripts, but only if you are already connected to a DB. I want to create one.
>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