Re: incompatibility with crystal reports?

From: Andrew Snow <andrew(at)modulus(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: incompatibility with crystal reports?
Date: 2002-10-14 06:37:49
Message-ID: 20021014163749.D490@esper.modulus.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


For the record, I will now now answer my own question :-)

The very latest driver (Oct 2002) has two options you must use for it to
work:

1. Untick "Text as longvarchar"
2. select "dont know" for "unknown sizes"

Thanks anyway,

Andrew

On Mon, Oct 14, 2002 at 03:35:19PM +1000, Andrew Snow wrote:
>
> For some unknown reason Crystal Reports doesn't like some of the fields
> coming from a postgresql database.
>
> CR v8 + Win32 + latest ODBC driver + postgres 7.2.1.
>
>
> What is happening is it won't let me 'browse data' for a field when
> selecting fields to report on, nor will it let me 'group by' any text fields
> - only integer.
>
> The "text as longvarchar" ODBC driver option seems to make no difference.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Kovacs 2002-10-14 07:30:41 Re: [JDBC] Prepared statement performance...
Previous Message Shridhar Daithankar 2002-10-14 06:13:46 Re: [HACKERS] MySQL vs PostgreSQL.