Connecting to Oracle

[outdoorsgal]

Can a cold fusion page on an Intranet connect to an Oracle database on another server?

[Dan Bracuk]

yes.

[Erewan]

Ok, so I have a problem.

I work at a college, and we use Banner as our ERP. Currently, our Banner
software package uses Oracle 9i as its database. Now I want to pull bits of
information out of that database for our website (course information,
schedules, et cetera), and i have designed a couple web applications using the
developer edition that need data from our Banner server.

Now here's the problem! We have the Education version of ColdFusion (which is
the same as the Standard Edition). My applications and such run fine on the
developer edition because it can connect to the Oracle? server using the built
in drivers. I CAN'T run them on the live webserver machine because the
Standard installation doesn't include the Oracle connection drivers.

I really don't want to shell out 6 grand to purchase the Enterprise edition
JUST for that one small (in the scheme of how much more robust the enterprise
edition is) driver.

Thus my question:
How the heck can I get my Standard Edition coldfusion to connect to an Oracle
database server?


The Webserver - Plesk running on a Red Hat Enterprise machine. Coldfusion is
installed side-by-side with Plesk.

[paross1]

These tech notes may help.

[url]http://www.macromedia.com/go/tn_18593[/url]

[url]http://www.macromedia.com/go/tn_18344[/url]

Phil