oracle driver not showing up

[nathangg]

ColdFusion MX, Version: 6,1,0,63958

I want to add an oracle data source, but "oracle" does not show up in the
driver drop down list for new data sources. Is there a way to add it?

Thanks in advance!
--
Nathan

[gclausen]

CFMX Standard does not have an Oracle driver but CFMX Enterprise does.
It's not possible to add a driver to the CFADMIN driver list. This of course
does *not* mean you cannot use a 3rd party driver, just make sure it's in the
Java Classpath and use the "other" driver along with the appropriate datasource
properties. It's documented here
[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/dataso16.htm[/url] and here
[url]http://www.macromedia.com/go/tn_18344[/url]

[paross1]

.....and you can download your particular version of Oracle JDBC drivers from OTN.

[url]http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html[/url]

Phil

[Dgcotton]

When you say "classpath" is this the class path for MX? Is this set in the administrator utility for MX?

[mxstu]

Yes in the "...ColdFusion MX Administrator's Java and JVM page..." . See the second link posted by gclausen for more information.

[Dgcotton]

do I just place the jar file from Oracle in a directory and then add that directory path to the "ColdFusion MX Administrator's Java and JVM page"?

Can it be placed into any directory?

[mxstu]

Yes, any directory should be fine as long as the location is appended to the
classpath in CFMX Administrator. Make sure to include the full path, file name
and ext. For example: C:\Oracle\ ora81 \jdbc\lib\classes12.zip