I have a new server I am setting up that I need to hook up with postgresql.
Here are the specs: RedHat Enterprise Linux 3ES PostgreSQL 7.3.10 CFMX 6.1 (due to customer constraints) I have tried to use the following drivers with no success: pg73jdbc2.jar pg73jdbc3.jar pg74.215.jdbc3.jar pg74.216.jdbc3.jar I thought that CFMX 6.1 came with the 1.4.1 jdk, so I should be using a jdbc3 driver...but none of them work for some odd reason. Here is the error I get in the cfadmin when I try to add and test the DSN: Connection verification failed for data source: asthma []java.sql.SQLException: No suitable driver available for asthma, please check the driver setting in resources file, error: org.postgresql.Driver The root cause was that: java.sql.SQLException: No suitable driver available for asthma, please check the driver setting in resources file, error: org.postgresql.Driver I have had this same exact config working on another server previously, using pg74.215.jdbc3.jar, however this does not want to work this time! I have added them to the class path and restarted the CF services as well, but no luck. I have been at it for several hours now...and am hoping that someone on this list can steer me in the right direction. Thanks, Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect Your PC from viruses, hackers, spam and more. Buy PC-cillin with Easy Installation & Support http://www.houseoffusion.com/banners/view.cfm?bannerid=61 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:4093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
