Sorry to keep this thread going but ... a couple of points I really have to stress ...
1. ODBC Bridge ... I was referring to the Sun ODBC bridge not the ODBC socket ... which might actually be fine, never used it. 2. CFMX Professional can use Oracle Native drivers, just not the ones OEMd by Macromedia. Simply get hold of the Oracle drivers from http://technet.oracle.com and configure them manually ... /opt/CFusionMX/runtime/servers/default/SERVER-INF/jrun-resources.xml is where this happens ... I think geoff mentioned fullasagoog.com has some info on this ... but if you know Oracle well enough to want to use it then this should be a trivial exercise ... ie you understand Oracle Networking cheers Mark ----- Original Message ----- From: "Craig Harcombe" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, February 01, 2003 12:01 AM Subject: [cfaussie] Re: Oracle and CFMX Hi All, Our experience with Oracle and CFMX Pro wasn't all bad (despite a premature, petulant bagging I posted to the list in the early stages because I was upset not to see Oracle in the driver list on Pro). We ported an app that was running on CF5 Ent to CFMX pro just to see. We used the JDBC thin client and after a little bit of mucking around it worked fine, except for an issue with the size of clobs the JDBC thin client driver could handle (on either an insert or update, I can't recall which one off the top of my head). Wondered what we could do, so we installed the Oracle ODBC driver and used the ODBC Socket, tested the queries involving large clobs and had no issues. It worked fine and we've got a not too busy production application running on it without any issues. We haven't updated the drivers since then, but there may be more joy in a newer model, who knows, anyone? Now, the initial mucking around was me. Once the "Oracle Savvy" person became involved, it took less than 10 minutes to set up each of the connections. The issue mentioned above was the only one that effected our application. I'm happy to admit the solution wasn't pretty so before anyone responds with a "What The...?" please note that it was a "let's see" exercise. However, it did show us was that both options were workable for our app. For what it's worth the application worked on CFMX Enterprise without any changes. So Mark, Geoff and Scott are all right, - the drivers were a bit dodgy and copped a bagging, - performance might be an issue by all accounts using the JDBC/ODBC bridge (but we only used it when we had to :-)) - if you haven't got an Oracle savvy person around it might be a bit of a mongrel to set up - Oracle does work better with Java than anything else, once you've used it you won't look back. What was the question? > Thanks for the reply what I was actually after was; Does >CFMX support ODBC drivers in the professional edition >or do you need to go to CFMX enterprise to use them? Oracle can be used using ODBC in the pro edition via the "bridge", but I wouldn't because there's a better alternative on Pro. If you want life to be really easy go for Enterprise, but you won't be buying it to use ODBC, surely!! Only other consideration is how you assess bang for buck. Regards Craig Harcombe Managing Director Danaclese Pty Ltd: http://www.danaclese.com.au AusTiger Hosting: http://www.austiger.com.au 32 Elder Street Lambton NSW 2299 Australia Phone: +61 2 4957 9958 Fax: +61 2 4957 0755 Email: [EMAIL PROTECTED] Visit MXDU: http://www.mxdu.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003 --- 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/ --- 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/
