>>>>>Yeah, odd question I know,but we've got a FPW system that needs to access VFP 3 tables.
>>>>>
>>>>>No, we can't bring the FPW system into VFP (no matter how MUCH I really want to), and I really REALLY don't want to convert the vfp file into a fox 2.x table.
>>>>I don't have 3.0 loaded but it works with 5.0.
>>>>Jeff
>>>
>>>I used Free tables not sure for dbc.
>>
>>Here is what I Did.
>>Set up system odbc drive for vfp, free tables pointing to correct dir.
>>
>>SET LIBRARY TO FPSQL ADDITIVE
>>nhandle=dbconnect('odbcname','','','')
>>sqlconn="SELECT * FROM dbfname"
>>ck=dbexec(nhandle,"&sqlconn","yourcursorname")
>>
>>HTH Jeff
>
>Jeff
>
>I'm having a day and then some, but your answer(s) are a tad bit confusing to me. You use this code to get FROM FPW to VFP? And which ODBC driver to you use?
Yes,
FPSQL Library comes with the connectivity kit, which I think was included with Professional Edition.
I set up a odbc driver using MS Visual foxpro driver 5.00.00414
I set it up as a system DSN but You should be able to use any type DSN.
I set up ODBC drive as VFP free tables.
Now remember I'm using 5.0 and I'm not sure 3.0 will work. Just playing with it for a little while I could not get data from a dbc, but that could be because I did not try very hard.
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com