Ernesto
One thing you might try is to see if you can access the PostgreSQL db
with a program other than CFMX.
I usually do my initial setup is with ViennaSQL (an interactive GUI SQL
Client), then copy the settings to CFMX Administrator.
Here's the URL for ViennaSQL
http://vienna.sourceforge.net/
Very easy to install & use.
HTH
Dick
On Thursday, September 12, 2002, at 11:09 AM, Ernesto Vargas wrote:
> Yes I have user a username and password, but its not
> require in Postgresql if its the same computer.
>
> I do have try chaging the jar file to postgresql.jar
> still no luck.
>
> Is there any log where you can see the error more in
> details?
>
> TIA,
>
> Ernesto Vargas
>
> --- Jillian Carroll <[EMAIL PROTECTED]> wrote:
>> I assume that you are actually enterine a username
>> and password and not just
>> leaving it blank?
>>
>> -----Original Message-----
>> From: Ernesto Vargas
>> [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, September 12, 2002 11:25 AM
>> To: CF-Linux
>> Subject: CFMX, RH 7.3, PostgreSQL JDBC drivers
>>
>>
>> I am having the following error:
>>
>> Connection verification failed for data source: test
>> []java.sql.SQLException: SQLException occurred in
>> JDBCPool while attempting to connect, please check
>> your username, password, URL, and other connectivity
>> info.
>> The root cause was that: java.sql.SQLException:
>> SQLException occurred in JDBCPool while attempting
>> to
>> connect, please check your username, password, URL,
>> and other connectivity info.
>>
>>
>> I have installed Postgresql JDBC 2 driver from
>> http://jdbc.postgresql.org/download/pgjdbc2.jar
>> under
>> /usr/coldfusionmx/lib where all standard CFMX .jar
>> files are.
>>
>> I am defining the datasource as follow:
>>
>> CF Datasource Name: Test
>> JDBC URL: jdbc: postgresql://localhost/gyn
>> Driver Class: org.postgresql.Driver
>> Driver Name: PostgreSQL
>> Username:
>> Password:
>>
>> Any body with advice?
>>
>> TIA,
>>
>> Ernesto Vargas
>>
>> __________________________________________________
>> Do you Yahoo!?
>> Yahoo! News - Today's headlines
>> http://news.yahoo.com
>>
>>
>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
