Hi Brett,
Just set up CF Standard with Oracle 9 and did some testing. Ended up using the OCI JDBC drivers.
What driver you end up using may depend on: a) the max length of your SQL statements. b) if you're using clobs or longs
The oracle ODBC driver is fine as long as all of your SQL statements are < 4K and you're not using clob or longs (for Oracle 8). The oracle 8 ODBC driver were not thread safe so I'd go with the Oracle 9 drivers if you can.
The OCI drivers work with SQL of any length [did some tests of several Mb in size] and work with clobs/longs/blobs fine. The OCI libraries to be installed on the server, SQL net configured and drivers placed in the java path in the CF administrator. You also need to use <cfqueryparam> esp for clobs otherwise you get odd truncation errors.
Another method I used in a previous project was to use native SQL connection between CF and SQL server and linked the Oracle tables to the SQL server - but this was only done as we had no control over the CF box. Worked fine for the problem although I was worried about the performance at the time.
Justin ============================================= Justin Mclean Class Software Phone: (02) 93321230 9 Chapman St Fax: (02) 93321032 Surry Hills Mobile: 0416 119 342 NSW 2010 =============================================
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
