Subject | Re: SQL-dialect 3 instead of 1? |
---|---|
Author | Marco Menardi |
Post date | 2007-02-10T02:29:37Z |
--- In IBObjects@yahoogroups.com, "guido.maucher" <Guido.Maucher@...>
wrote:
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
wrote:
>I think that you have to BUILD the database with the dialect you want,
> 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
>
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