if the oracle server box has multiple instances running, it must have
multiple listeners. you must have multiple service names on your cf machine.
say two service names: ORCLONE.WORLD and ORCLTWO.WORLD corresponding to the
listeners on your oracle server: create separate datasources (or use native
connectivity drivers) on each service.
O-
----- Original Message -----
From: "Alex" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 8:45 PM
Subject: oracle multi homes on solaris
> I have a oracle on a solaris box and CF on a seperate solaris box.
> The oracle box has multiple instances running. I need to know how to
connect
> to specific instances from CF. Do I just need to create 2 datasources or
do I
> have to change ORACLE_HOME in the startup script somehow?
> thanks
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
