Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL - Mailing list pgsql-jdbc

From Prasanth
Subject Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL
Date
Msg-id LGEKIACNKCMPMALCJMLOGENLEBAA.dbadmin@nqadmin.com
Whole thread Raw
In response to Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
>Right, but I'd assume that CR has some way to configure the
>user/password it uses if it's using the first form, at least..

I do specify the username & password. CR is able to connect to the database
at design time. I use JDBC connection even for designing the report. I works
great at design time. It is during runtime that the report is not able to
connect.
It could well be CR bug, I even emailed their tech support but no response.

>Can you try the protocolVersion=2 approach and see if that works?

Same error message.

P.S: I am using postgresql-8.0-310kh.jdbc3.jar driver

-Prasanth.

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Oliver Jowett
Sent: Wednesday, March 09, 2005 4:19 PM
To: Prasanth
Cc: Rover, Mischa de; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Crystal Reports: Connection rejected: FATAL: no
PostgreSQL


Prasanth wrote:
>>- pass it to DriverManager.getConnection(url, user, password)
>>- pass a "user" property when calling DriverManager.getConnection(url,
>>properties)
>
>
> These two options can't be used as its done by Crystal Reports at runtime.

Right, but I'd assume that CR has some way to configure the
user/password it uses if it's using the first form, at least..

>>- pass it in the URL: jdbc:postgresql://host:port/database?user=username
>
>
> I tried this but getting the same error message Logon Failed.
> (I am not able to include the message in my server log as it seems to have
> broken.
> No messages since yesterday. Not sure why my logging has stopped)

Strange..

Can you try the protocolVersion=2 approach and see if that works?

-O

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings





pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL
Next
From: Charl Gerber
Date:
Subject: timestamp issues