All: I upgraded cf8 to cf 9 and now the previous data source on jdbc broke. It said no suitable driver. I downloaded ojdbc6.jar from Oracle and placed in here: C:\ColdFusion9\runtime\jre\lib\ext\, and also set the class path on CF Admin page(Sever Settings - Java and JVM) like this: C:\ColdFusion9\runtime\jre\lib\ext\ojdbc6.jar
And Now it says "java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor". But I don't use SID as my DBA gave me Oracle service name. The string works fine in Oracle SQL Developer command line. Has anyone seen this and know how to fix it? I am on Oracle 11g. and the entry on jdbc is: JDBC URL: jdbc:oracle:thin:@[my host name]:1521:[my service name] Driver Class: oracle:jdbc.OracleDriver Thanks in advance. Nathan Chen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
