If you're using the JDBC drivers that come with CF to connect to Oracle, I don't think you need a tnsnames.ora file at all. You set all the necessary parameters right in the CF datasource admin: the SID name, the server, the port, and if desired the user name and password.
On 5/12/06, Eddie Trinidad <[EMAIL PROTECTED]> wrote: > > 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:240374 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
