MX7 - Oracle 9

[sersasa]

I had CF5 and it was working with Oracle 9i, i upgraded to MX7 and not it does not connects anymore, the installation kept all the settings and datasources.... any ideas ?

[oldie74]

Hi,
the installation replaces the java class path for the oracle jdbc driver. You
should configure the class path in the cf-administrator. Add an entry like
"C:/oracle/ora90/jdbc/lib". Make sure you have the right oracle jdbc-driver in
this drirectory. in my case it's the "ojdbc14.jar"-file for a 9i-Database.

[remecTim]

We're having the same problem... I thought this sounded like the answer, but it makes no difference... any other ideas?\

[Tom Jordahl]

What is the error?

--
Tom Jordahl
Macromedia Server Development

[nicetim]

[url]http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/fp_frameset[/url]
..html

I read here that only Enterprise edition can even access Oracle databases.
That sucks if it is true, because we have a standard edition MX6.1 install now
and want to upgrade, but cant see paying enterprise prices for access to Oracle.

Please someone tell me that i am wrong.

Tim

[paross1]

I suppose that you could configure it as an "other" data source.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18593[/url]

Or, there is always an ODBC socket connection if you are on a Windows box, but
that is a last resort option in my opinion.

Phil

[nicetim]

Thats true, we do have it setup as an Other type driver and point to the JDBC url like:
jdbc:oracle:thin:@server:1521:DSN
Will this work with the standard edition of MX7?

[paross1]

As far as I know it will. I am not aware of any differences between MX 6.1 and 7 in this regard.