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