> Does anyone have any experience getting an Oracle ODBC > connection to work in ColdFusion MX? We were using the native > driver, which uses JDBC, and were surprised to find out that > we needed to purchase the "Enterprise" version (rather than the > "Professional" version we already had) in order to continue > using this connection. > We've tried downloading the latest Oracle drivers, using > an ODBC socket connection, and using the MS drivers, but > nothing is working. I saw a couple of posts in the Macromedia > forums that suggest reverting to an older Oracle driver, but > before I try this, I thought I'd ask for other thoughts from > this list. Is it really this difficult to get CF MX to play > nicely with an Oracle database?
Rather than trying to get ODBC connectivity, you might try using Oracle's own JDBC drivers: http://technet.oracle.com/software/tech/java/sqlj_jdbc/content.html You'll probably have to do some tweaking (in the configuration files directly rather than using the CF Administrator) to set this up, but I've done something similar with the MS SQL Server JDBC driver from Microsoft, and it wasn't that hard. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
