Looks like your ODBC settings might have changed in the switch. In
particular, look at the " text as longvarchar" setting.
If you cannot find a solution, try posting to the pgsql-odbc list.
"Kristina Magwood" <kristina(at)nanometrics(dot)ca> wrote in message
news:OF743BE08C(dot)75D3E472-ON85256FE1(dot)0044467B-85256FE1(dot)0044B2C6(at)nanometrics(dot)ca(dot)(dot)(dot)
> Hi,
> We are updating from v7.3 to v8.0.1 as well as transferring the database
> to a new machine. We use Crystal Reports 9 to access the data on a
> production basis. Unfortunately, Crystal Reports 9 fails to recognise
> some of the data fields on the new database. In particular, it does not
> recognise VARCHAR 256 and larger. Any ideas?
> Thanks,
> Kristina Magwood