Hi Simon,
That newest VFP ODBC Driver produced by Microsoft is for VFP6. DevArt has a driver that works for VFP9 data types, as Barry has mentioned.
VFP ODBC drivers works just as any ODBC driver works. You just have to know the connection string properties. DevArt will supply that information. In general, www.connectionstring.com has specs for all the common drivers.
Code:
lcConnStr = "your connstring goes here"
lnHandle = sqlstringconnect(lcConnStr)
ln = sqlexec(lnHandle,"select fielda, fieldb from tablea","mycursor")
The connstring info and the sqlexec select string can be used in a Virtual Table.
hth,
Hank
PS: unless you have to keep the old code running, the better choice is to move everything over to Lianja.
PPS: to find the VFP6 ODBC Driver, google (without the quotes) "vfp odbc driver download" I would strongly suggest getting the DevArt ODBC driver to avoid gotchas. I don't have a comprehensive list, but you can find references on the web with a little searching.
Bookmarks