> Actually what I am trying to do is to use JDBC by choosing "Other" > rather than "ODBC Socket" on CF Admin data source setup page, and what I > need are the values/syntax for these entries: > > JDBC URL: > Driver Class: > Driver Name: > > I looked the documentation but still don't know what to enter. Has > anyone done this before?
The driver and class name will be drawn directly from the documentation. The documentation will contain examples of the JDBC URL, which you'll then have to change for your specifics (server name, port, username/password). Here's what I found from a Google search of "datadirect jdbc oracle example": http://media.datadirect.com/download/docs/connectsqlxml/jdbcug/jquiksta.htm JDBC URL: jdbc:datadirect:oracle://server_name:1521 Driver class: com.ddtek.jdbc.oracle.OracleDriver I don't think it matters what you enter for driver name, but I could be wrong there. Now, in addition to installing the driver, you have to actually set it up in the classpath for CF to be able to use it as well. And the DataDirect drivers aren't free - if you're using CF Standard, I recommend that you use Oracle's own JDBC driver instead. http://blog.razuna.com/2008/01/25/configure-the-jdbc-driver-for-oracle-on-coldfusion-8-standard-edition/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
