Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC Anyone ?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00142603
Message ID:
00142606
Views:
31
>I have developed an app in VFP 5.0. A third party wants to read and write to fields in one of my tables (I set aside fields for him to do so). However, his application is a 16 bit app, and he claims his ODBC drivers will not work. Any ideas ????
>

If your stuff is part of a .DBC, or includes any of the new data types, or has even been modified in structure under VFP, he may well not be able to read the file with a DBASE or pre-VFP FoxPro driver; I don't know if there's a 16-bit VFP 3 compatible driver, but am pretty certain that there is no 16-bit VFP 5 compatible driver.

The easiest solution is to make the tables free tables, and to convert them to older-style headers by using COPY TO...TYPE FOX2X to convert the headers, assuming that no new data types are in use (things like Integer, Currency, Date/Time fields can't be in any of these tables, since they aren't supported prior to VFP.) VFP can manipulate the free tables, but you need to be careful not to do anything that will alter the table structure from VFP, or the free tables will not be readable with the older drivers.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform