Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro 8.0 ODBC
Message
 
 
To
25/09/2006 13:51:47
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01157008
Message ID:
01157125
Views:
15
>Where can I find the Visual FoxPro 8.0 ODBC Driver?

In terms of having ODBC functionality, I think you can use the VFP OLEDB driver from VFP8 as well as the VFP9 OLEDB driver just like the ODBC driver that came with VS6/VFP6. That's what we do with our ASP apps that use VFP tables for web applications. i.e., we use ADO in VBScript or server-side Javascript to connect to the VFP8 OLEDB driver.

There are some (annoying) behavior differences between the VFP8 version and the VFP9 version that I've complained about here. In particular, unless you use Set Enginebehavior (which the VFP9 driver supports but I think the VFP8 driver does not), the value returned from an aggregate function such as a COUNT() function will be NULL instead of 0 if there are zero hits. ...or something like that. Without making code changes, this breaks ASP apps that work fine with the VFP8 driver, and that's why we're still using the VFP8 driver. As far as using the OLEDB driver instead of the older ODBC driver, all we had to do was change the connection string. In VBScript:
if USE_OLEDB then 
  cConnStr="Provider=VFPOLEDB; " + _
    "Mode=ReadWrite|Share Deny None;Data Source=" & cDataSourcePath 
else 
  cConnStr="Driver=Microsoft Visual Foxpro Driver; " + _
        "SourceType=DBF;BACKGROUNDFETCH=NO;SourceDB=" + cDataSourcePath
To the best of my knowledge, versions are:

6.1.8630.1 VFPODBC.DLL latest build AFAIK

8.0.0.3117 latest VFP8 OLEDB driver

9.0.0.3504 latest VFP9 OLEDB driver (released with SP1)
Previous
Reply
Map
View

Click here to load this message in the networking platform