General information
Title:
Accessing vfp through ODBC
i am trying to access a vfp database through the microsoft odbc driver version 5.00.00xx.
my application works fine until the I added the 50th field to one of the tables. at that point the driver reported an error 'SQL statement too long'. actually, i can get a few more fields if i shorten the field names. the problem seems to be with the overall length of field names. (it seems that the driver formats a sql string containing all field names even if only one is being updated).
this happens if i access the database with VB and RDO or using Delphi's database explorer. so i am reasonably certain that the problem is with the odbc driver.
question:
is there a better or more recent driver?
is there a better way to access vfp data from a front-end application?
thanks
bill
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only