Sounds good, Greg. Chris
Greg Luce wrote: > 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 >>>> >>>> >>>> >>>> >>>> >>> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
