It just took a dump... I dunno...worked fine before yesterday...And I have
another box up (same Win2k/Apache/CF5 config) where the Native drivers
work fine. I'm trying to find the difference...
Yeah, I've got most of my date code like that already, just had to find
the stragglers and and fix them. I'd stay on the ODBC drivers, but I'm
still having some problems with certain queries.
> 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
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
