> Anybody know a good set of native jdbc drivers for Oracle 9i that > work with CFMX?
Grant - Several points to this effect, it can depend. 1) Are you using Pro of Enterprise? Enterprise comes with it's own Merant JDBC driver that works a treat. Given the option, work with that. However, pro doesn't give you that driver. For Pro Oracle/Macromedia suggest one of 2 options, and depending on circumstances, use the one you need. 1) Oracle JDBC Thin Client. This JDBC driver DOES NOT require that the Oracle 9i client be installed on the system that is hooking into the database. Can be downloaded from here: http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html Technotes on setting it up can be found here: http://www.macromedia.com/support/coldfusion/ts/documents/tn18344.htm The bad thing about the Thin client is that (a) stored proc's in must be PROCEDURES and NOT FUNCTIONS. (Under the merant driver, it doesn't seem to care too much) and, (b) the BIG drawback is that any proc you do have, will throw an error if you try and return a result set. 2) Oracle ODBC driver. This ODBC driver DOES require that you install the 9i client on the server so it can be used. Can be downloaded from here: http://otn.oracle.com/software/tech/windows/odbc/content.html (May need to also download the Oracle Universal Installer) Bad thing about this one - again, stored Procs, MUST be procs - HOWEVER, yuo can now return result sets from a stored procedure without any problem. I have yet to see any major performance difference between the two. Without any testing, I feel like the ODBC one is faster, but that could just be because the Thin client one would always throw an error on all my stored procs. If you have any problems let me know. Getting my drivers set up for Pro took me 3 days or so of trial and error. The docs don't cover it too well. So if I can aid someone else in missing all the pain and suffering I went through, hopefully it will be worth it ;o) HTH. Mark ----------------------------------- [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [www.safefrombees.com] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
