Gladly. Thanks. -CF Standalone w/Apache -/opt/coldfusionmx/wwwroot/WEB-INF/classes/ -here are the values for the datasource: CF Datasource Name: asthma JDBC URL: jdbc:postgresql://127.0.0.1/asthma Driver Class: org.postgresql.Driver Driver Name: PostgreSQL Username: asthma Password: ****************
I would appreciate any ideas... On 12/17/05, Cliff Meyers <[EMAIL PROTECTED]> wrote: > 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:14:4095 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
