From: | "Prasanth" <dbadmin(at)nqadmin(dot)com> |
---|---|
To: | "Oliver Jowett" <oliver(at)opencloud(dot)com> |
Cc: | "Rover, Mischa de" <mischa(dot)de(dot)rover(at)capgemini(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL |
Date: | 2005-03-09 22:49:33 |
Message-ID: | LGEKIACNKCMPMALCJMLOGENLEBAA.dbadmin@nqadmin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Oliver Jowett
Sent: Wednesday, March 09, 2005 4:19 PM
To: Prasanth
Cc: Rover, Mischa de; pgsql-jdbc(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Charl Gerber | 2005-03-10 14:03:45 | timestamp issues |
Previous Message | Oliver Jowett | 2005-03-09 22:18:54 | Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL |