Thanks Chris. I'm evaluating the Datadirect ODBC driver now, and I'll try the JDBC one you recommend. It sounds great. I'll post my findings.
Greg On 3/16/07, Christopher Jordan <[EMAIL PROTECTED]> wrote: > > Greg, > > I'm really, **REALLY** surprised that Adobe doesn't have some article or > technote or something about accessing Visual FoxPro via the JDBCODBC > bridge. > > I spent *TWO YEARS* going back and forth with then Macromedia, and we > were finally able to find the *real* answer to all of our intermittent > nastiness. > > The VFP ODBC driver is *NOT THREAD SAFE*! Ugh... you don't know what > kind of headache it was to finally figure that out. We had to build a > test case that would cause a failure at the click of a button in order > to get Adobe to even get their engineers to look at it. Once we did, it > was just a day or two for them to find the problem. > > Microsoft knows that the VFP ODBC driver isn't thread safe and their > answer was to drop support of the ODBC driver in favor of the OLEDB > variety. Unfortunately, ColdFusion doesn't speak OLEDB. :o( > > My last response has the only link I was ever able to find during the > whole two year ordeal that had a Type 4 JDBC driver for FoxPro. > > We've got some minor issues with it, where we think it's corrupting our > indexes (but not always), and they're working with me to find the > problem. If you're using nice recent FoxPro tables (say anything post > version 6), you probably won't have those problems. I'm pretty convinced > our problems are because we're being forced to use such ancient FoxPro > tables. > > Chris > > Greg Luce wrote: > > That article just explains setting up an ODBC Socket dsn. I have already > > done that but I get alot of inconsistent behavior out of it. Sometimes > > errors, and sometimes joined queries are just worthless no matter if > they > > are indexed properly and run well from the VFP terminal. I just saw that > > there were at one time Merant drivers for Foxpro. I can't find anything > on > > them now though. > > > > Greg > > > > On 3/16/07, Robertson-Ravo, Neil (RX) < > [EMAIL PROTECTED]> > > wrote: > >> Have you followed this? > >> > >> > >> > http://www.fusionauthority.com/Techniques/4556-Accessing-Visual-FoxPro-Datab > >> ases-with-ColdFusion.htm > >> > >> > >> > >> > >> > >> > >> > >> > >> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > >> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed > Business, > >> Registered in England, Number 678540. It contains information which is > >> confidential and may also be privileged. It is for the exclusive use > of > >> the > >> intended recipient(s). If you are not the intended recipient(s) please > >> note > >> that any form of distribution, copying or use of this communication or > the > >> information in it is strictly prohibited and may be unlawful. If you > have > >> received this communication in error please return it to the sender or > >> call > >> our switchboard on +44 (0) 20 89107910. The opinions expressed within > >> this > >> communication are not necessarily those expressed by Reed Exhibitions." > >> Visit our website at http://www.reedexpo.com > >> > >> -----Original Message----- > >> From: Greg Luce > >> To: CF-Talk > >> Sent: Fri Mar 16 13:58:52 2007 > >> Subject: Visual Foxpro Drivers? > >> > >> Are there JDBC or 3rd party ODBC drivers for Foxpro? I found one > technote > >> that said Merant made some, but the link took me to another site > >> http://www.serena.com/ where I wasn't able to find it. > >> > >> Anyone have experience running CF with Foxpro? The ODBC Socket dsn > we're > >> currently running just isn't cutting it. > >> > >> Greg > >> > >> > >> > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
