Hello Marco,
the database was created with dialect 1, and I checked the result - it
is really 1.
Thanks
Guido

--- In IBObjects@yahoogroups.com, "Marco Menardi" <mmenaz@...> wrote:
>
> --- In IBObjects@yahoogroups.com, "guido.maucher" <Guido.Maucher@>
> wrote:
> >
> > The database application for our measurements is written with Delphi5
> > for SQL-dialect 1.
> > Now we moved from Interbase 5.5 to Firebird 2.0,
> > but want to keep (at least during the beginning) the dialect 1.
> > This worked fine with IBO 4.7 beta 11. But with the actual IBO
beta 15,
> > it looks like
> > the database-connection is made with dialect 3. The dialect-field in
> > TIB_Connection is set to 1, but this does not help.
> > Are there other settings necessary?
> > Thanks
> > Guido
> >
> I think that you have to BUILD the database with the dialect you want,
> is not a connection issue only.
> So you have to run a script like:
> SET SQL DIALECT 1;
> SET NAMES NONE;
> CREATE DATABASE 'E:\Data\MYDATABASE.FDB'
> USER 'SYSDBA' PASSWORD 'masterkey'
> PAGE_SIZE 1024
> DEFAULT CHARACTER SET NONE;
> ...
>
> Of course the connection dialect have then to match the one used for
> database creation, so the client know what to expect from the server
> capabilities, I guess.
> regards
> Marco Menardi
>