Good afternoon HOF users, I'm a first time poster and I'm a business analyst... so I'm not that tech savvy.
I maintain our office CF server Jacksonville that links up with an network operation center in KC. Well they did this migration thing of Oracle 10g and our webserver can't connect with Oracle. I tried to modify the Data Source in the administration page but I don't see an entry for Service_name (no more SID in the tnsnames.ora file). So how do I add on the service_name for an Oracle data source? http://127.0.0.1:8500/CFIDE/administrator/datasources/oracle.cfm?dsn=OCDB has no service_name field. :( Thanks and have a good day. Eddie Trinidad 904-219-3288 [EMAIL PROTECTED] [EMAIL PROTECTED] Here's my troubleshooting trail: TNSNAMES.ORA OLD********************* jea.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 148.80.159.14) (Port = 1526) ) ) (CONNECT_DATA = (SID = jea) ) ) NEW************************ jea.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 148.80.116.5) (Port = 1526) ) ) (CONNECT_DATA = (SERVICE_DATA = jea) ) ) ************ Error Message Connection verification failed for data source: OCDB []java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (jea) was not recognized by the Oracle server. The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (jea) was not recognized by the Oracle server. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
