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? Nathan Chen -----Original Message----- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Thursday, August 04, 2011 1:08 PM To: cf-talk Subject: RE: CF 9 ODBC data source with Windows 2008 64-bit Dave and All: I downloaded and installed JDBC 4.2 from DataDirect site. Now I am not sure what the strings on the CF Admin data source setup page should look like. I select "Other" on the driver drop-down and on the second page: should I enter these? JDBC URL: jdbc:oracle:@myDBServer.myDomain.com:ORCL Driver Class: oralce.jbdc.OracleDriver Driver Name: oracle.jar How about the connection string field in the advanced settings section? Can someone who has done this before help me out? I am using Oracle 10g and Win 2008 R2 64-bit. Nathan -----Original Message----- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, July 25, 2011 11:20 AM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit > I am guessing this issue has been discussed but I just haven't followed > it. In my production server(Windows 2008 R2 64-bit), I installed Oracle > 11g client and I was able to connect to my Oracle 10g DB via the odbc > DSN I created. But when I went to CF Admin and tried to create a DSN > using ODBC Socket driver, it gives me this mismatch error. Is it possible for you to use the JDBC driver instead - either CF (DataDirect) or Oracle? If not, you'll need to download and install a 64-bit Oracle ODBC driver, if such a thing exists. But I'd recommend using JDBC if at all possible. 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:346557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
