dunno what to tell ya, but I will say some of us found the MS ODBC drivers to work
well with Oracle and CF5. Yeah, dates are a PITA, just use Oracles TO_DATE()
function...TO_DATE('12/31/2003','MM/DD/YYYY')
Doug
>-----Original Message-----
>From: Tony Schreiber [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, August 06, 2003 9:51 AM
>To: CF-Talk
>Subject: Native Oracle Driver Sucks, ODBC Ok. What happened?
>
>
>Ok, this just started happening today. For some reason (I wish
>I knew and
>hope someone can help) my Oracle db is just crawling...
>
>Web Server: Win2k/Apache/CF5
>DB Server: Win2k/Oracle805
>
>Queries with any utility work fine.
>Queries using the ODBC driver in CF work fine*.
>Queries using the Native driver take FOREVER!
>
>*not fine enough. I have some date issues with the ODBC driver...
>
>So what should I be looking for? It used to run just fine.
>What the hell
>happened? I tried the CF_ORA_WAIT env variable but not change. Most
>queries will eventually return, but take 10-100 times longer than they
>should. I'm lost!
>
>Tony Schreiber, Senior Partner Man and
>Machine, Limited
>mailto:[EMAIL PROTECTED]
>http://www.technocraft.com
>
>http://www.is300.net The
>Enthusiast's Home of the Lexus IS300 since 1999
> ***** PARTS STORE NOW OPEN ***** http://www.is300.net/store/
>http://www.simplemessageboard.com Free Forum Software for
>Cold Fusion
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
