Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPW2.6 ODBC to VFP3??
Message
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00080837
Message ID:
00080910
Views:
26
>>>>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?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform