> 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:244435 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
