Subject | Re: [IBO] Convert to IB6 |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2001-01-21T21:09:37Z |
> >I have converted my DB to IB6Before it was Version 5.6 and now it's Version 6 with Dialect 3.
>
> 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?
>
>No, in Version 5.6 the columns were DATE (the old DATE-TYPE). After
> >and changed the TIMESTAMP-columns to
> >DATE-Type.
>
> Are you saying you had TIMESTAMP columns in the previous version?
conversion to Version 6 these columns are TIMESTAMP and then I changed the
type to DATE (the new DATE-Type)
>The same.
>
> >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?