| Subject | Re: [firebird-support] Can't Get Started |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-02-13T12:52:11Z |
At 10:56 PM 13/02/2008, you wrote:
SET SQL DIALECT 3;
By default, Fb 1.5 and higher should be in dialect 3 so the SET SQL DIALECT 3 command isn't usually necessary. It's only really a problem if you've previously been connected to a dialect 1 database and isql is in dialect 1. But I always include it to be on the safe side.
./hb
>Thanks to both of you.Missing keyword SQL.
>When I entered the complete command on a single line, the database was created.
>I don't know if it was necessary, but the command "set auto on;" worked (whatever it did), however:
> (1) the command "set dialect 3;" failed with a command error
SET SQL DIALECT 3;
By default, Fb 1.5 and higher should be in dialect 3 so the SET SQL DIALECT 3 command isn't usually necessary. It's only really a problem if you've previously been connected to a dialect 1 database and isql is in dialect 1. But I always include it to be on the safe side.
> (2) after the create, I did not receive any message about the database being created or connected.No, you're right, you don't. :-) You do on a normal CONNECT.
>I was able to connect to the DB with IBQ so I assume (at this point) that everything is OK.Yup. But you can do a SHOW DATABASE in isql, or run gstat -h <path to your database> for verification of what you created.
./hb