Thread: Crystal reports 9 fails to recognise data on upgrade to 8.0.1 odbc problem?

Crystal reports 9 fails to recognise data on upgrade to 8.0.1 odbc problem?

From

Kristina Magwood

Date:

12 April 2005, 15:56:44

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.

Jeff Eckermann suggested that the ODBC settings were different on the new machine.
"In particular, look at the " text as longvarchar" setting."
But the text as longvarchar setting is set on the new machine.

Any ideas?

Thanks,
Kristina Magwood

Re: Crystal reports 9 fails to recognise data on upgrade to

From

Kelly Burkhart

Date:

12 April 2005, 18:46:26

On Tue, 2005-04-12 at 10:56, Kristina Magwood wrote:
> 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.
>
> Jeff Eckermann suggested that the ODBC settings were different on the
> new machine.
> "In particular, look at the " text as longvarchar" setting."
> But  the text as longvarchar setting is set on the new machine.
>
> Any ideas?
>
> Thanks,
> Kristina Magwood

Try setting 'MaxVarcharSize = <number bigger than 256>' in your
odbcinst.ini file.

-K