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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings