No, I haven't tried the JDBC-OCI driver. The Thin client driver won't return ref-cursors as result sets, and I couldn't find any information on the JDBC driver. I will definitely look into it though. As to the DataDirect drivers I did get them from DataDirect, Adobe won't give them to you. I'm trying to get a price quote on them and I think you're probably right that it's more cost efficient to buy Enterprise. They don't seem real eager to tell me the actual cost.
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 12:33 PM To: CF-Talk Subject: RE: DataDirect drivers and CFMX Standard > We're using the CF Standard version and trying to connect to an Oracle > Database (and actually use it in a meaningful way). > What we've discovered is this is pretty much down-right silly if you > want to use stored procs. Have you tried Oracle's own JDBC drivers? If I recall correctly, they have a type 4 JDBC driver and a JDBC-OCI driver. > In order to see if we can fix the problems I downloaded the DataDirect > drivers (which appear to be THE way to connect to Oracle). Drivers > are installed, I can test the connection using the tool that comes > wtih them, and you'd think everything would work... but NO, I get a > timeout error everytime I try to connect to my database. I'm assuming > that the problem is my connection string since it's obviously finding > the driver, but I can't figure it out. > > Has anyone else out there done this? I'm going to call Adobe in the > morning, but I thought maybe someone could just toss me the answer. > > Connection Information I'm using: > Driver Class: com.ddtek.jdbc.oracle.OracleDriver > URL: jdbc:datadirect:oracle://ASG2KDEVODB01:1521;ServiceName=DBKDEV1 > > CF Class Path: > c:/work/ColdFusion/drivers/lib/base.jar,c:/work/ColdFusion/dri > vers/lib/util.jar,c:/work/ColdFusion/drivers/lib/oracle.jar > > I had to configure it as a type "Other" since the Data Direct drivers > don't come wtih standard. Any help at all would be appreciated. Did you download the DataDirect drivers from Adobe, or from DataDirect? The Adobe version should not allow you to connect to Oracle from CF Standard - that's one of the big selling points for CF Enterprise, actually. If you get the drivers directly from DataDirect, they should work, but they're expensive enough that you'd be better off upgrading to CFMX Enterprise. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244447 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
