| 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: | Whole Thread | Raw Message | 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.
| 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. |