Thank you for the info! We made the change to specify that the
connection was to use Dialect 1, but we get the same problem. We are
preparing a set of test cases for you.

Thanks,
Steve

Roman Rokytskyy wrote:

>
> > Thank you Helen for the information. We did a backup on the Interbase
> > 5.6 and then restored the gbk to an fdb file on the Firebird server.
> > The ODS version is 10.1. How do we set the Dialect level in the
> > client? I thought this was a database level thing and did not realize
> > that the Jaybird client needed to be set to Dialect 1 as well...
>
> If you wish to connect in dialect 1, you have to specify connection
> property (sqlDialect=1):
>
> http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:driver_config
> <http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:driver_config>
> http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:connection_properties
> <http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=config:connection_properties>
>
> By default client dialect is 3.
>
> Roman
>
>