On 3/1/2004 at 11:53, you wrote:
YA> I used to following info:
YA> Driver: Other
YA> JDBC URL: jdbc:postgresql://server:port/database
YA> Driver Class: org.postgresql.Driver
YA> I entered the username and password that I created. I got an
YA> error.. (sorry didn't write it down), it couldn't connect to the
YA> DB. Now, when I tried to modify the info that I entered, I get
YA> this error: "File not found: /datasources/postgresql.cfm "
YA> Anyone have any suggestions?
YA> I did look in the datasources folder, and such a file does not
YA> exist... I could see one for Oracle, MySQL.... but no PostgreSQL.
The instructions at Jochem's site* worked for me mostly, though I had
to add my PostgreSQL server's port number to the JDBC URL**. Without
the port number, I got that same misleading postgresql.cfm error.
There was a postgresql.cfm file in MX6.0, but it is apparently not
used in MX6.1 at all; however, there seem to be some references to it
remaining in MX6.1's CF Admin.
To remove/correct the flawed DSNs, edit /opt/coldfusionmx/lib/neo-query.xml
Here's how my RH 9/MX 6.1/PostgreSQL 7.3.4 JDBC URL's are formatted:
jdbc:postgresql://127.0.0.1:[PostgreSQL port number]/[database]
(*) http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16
(**) http://jdbc.postgresql.org/doc.html#load (see JDBC URL section)
Hope that helps!
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
