Oracle Service Names are also called Database Aliases. They're in the tnsnames.ora
file. (CF 4.5.2, Solaris 8, Oracle 8i)
Here's a typical example. PONE6.WORLD is what you'd enter as a host string when
configuring CF to talk to Oracle. If sqlnet.ora has "names.default_domain = world"
then you can leave off the .WORLD (in this example), I think.
PONE6.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SID = PONE6)
)
)
More info "Connecting to Oracle 7.3/8.0 Databases" in the Administering CF
documentation.
Chris Norloff
---------- Original Message ----------------------------------
from: "Kris Pilles" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 15 Jul 2002 12:19:56 -0400
>Can anyone tell me where I can find the oracle service name's
>location???
>
>Thanks
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
