Can you please reply with the following information? - CF standalone or multiserver (JRun) install - Where you're putting the JDBC driver .jar file - Values you're entering for all fields on the data source page
On 12/16/05, Josh <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:4094 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=89.70.14 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
