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 >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
