ColdFusion 8 and Oracle

[dviVijay]

Hi All,

I'm new to this ColdFusion thing...

I installed ColdFusion 8, then Oracle 10g... I read this doc:
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=installj2ee_14.html

And ata glance it seems like I should have installed Oracle *first*... Is this correct?

TIA - Vijay

[Kronin555]

Are you trying to run Coldfusion on Oracle's application server? or are you trying to have Coldfusion talk to an Oracle database? or are you trying to run Coldfusion on Oracle's application server, and have it talk to an Oracle database?

[Newsgroup_User]

dviVijay wrote:
> Hi All,
>
> I'm new to this ColdFusion thing...
>
> I installed ColdFusion 8, then Oracle 10g...

An Oracle 10G database server or the 10G application server?

For the former it should not matter, other then I've never had both
running on the same server. But I suppose a strong machine not meant
for heavy production use could handle it.

The article you linked to is how to use the Oracle 10G Application
server as the JAVA engine to run ColdFusion, rather then the bundled
JRUN4 that comes with ColdFusion. This is, I suspect, a rather unusual
configuration, but apparently supported by ColdFusion AKA Adobe, so yeah
if you are bent that way.

[dviVijay]

Kronin555 - we are trying to set up a datasource for coldfusion to talk to Oracle's database. So I think it's your second one.

Ian Skinner - this is what was downloaded and installed:
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html

Thanks for the replies, and me sorries again for not knowing too much about this stuff.

[Newsgroup_User]

>
> Thanks for the replies, and me sorries again for not knowing too much about
> this stuff.
>

Then you should be good to go... Set up your oracle schema AKA database
AKA user(s) as desired and then create DSN(s) in the ColdFusion
administrator.

What drivers you have available to you will depend on what version of
ColdFusion you have. Enterprise or Developers you have the Native
ORACLE JDBC driver. Otherwise you will need to use the Oracle Java Thin
Client or, usually, worse case the Jave-ODBC bridge.

All these options are well documented and discussed.