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@nanometrics.ca> wrote in message
news:OF743BE08C.75D3E472-ON85256FE1.0044467B-85256FE1.0044B2C6@nanometrics.ca...
> 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