Subject Re: [IBO] Convert to IB6
Author guido.klapperich@t-online.de
> >I have converted my DB to IB6
>
> What version was it before conversion? Which dialect are you trying to
> use? What do you see in the SQLDialect property of the IB_Connection?
>

Before it was Version 5.6 and now it's Version 6 with Dialect 3.

>
> >and changed the TIMESTAMP-columns to
> >DATE-Type.
>
> Are you saying you had TIMESTAMP columns in the previous version?

No, in Version 5.6 the columns were DATE (the old DATE-TYPE). After
conversion to Version 6 these columns are TIMESTAMP and then I changed the
type to DATE (the new DATE-Type)

>
>
> >With IBConsole I can open the tables, but when I try to open
> >the altered tables with a IB_Query, I get the error
> >Dynamic SQL Error
> >SQL error code=-804
> >Incorrect values within SQLDA structure
>
> What do you see in your IB_Monitor?

The same.