Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where are the VFP - ADO samples
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00517827
Message ID:
00517900
Views:
17
This message has been marked as the solution to the initial question of the thread.
Chuck,
Let's see if we can find the banana :)
Try the following:
oConnection = CreateObject("adodb.connection")
lcConnectionString = "Driver=Microsoft Visual Foxpro Driver; " +;
                     "UID=;"+;
                     "SourceType=DBC;"+;
                     "SourceDB=C:\Program Files\Microsoft Visual Studio\MSDN98\98VS\1033\Samples\VFP98\data\TestData.dbc"
oConnection.open(lcConnectionString)
oRecordSet = CreateObject("adodb.recordset")
oRecordSet.Open("SELECT * FROM customer", oConnection) &&
?oRecordSet.fields(1).value && Alfred's Futterkiste
Does this work for you?
HTH

>Good reference but no banana. I used the following string with no result:
>
>connectstring = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\\tlhadm4\ihpdata\finacct\bankv6"
>recordsource = bank
>
>What's missing? This is pretty much the cocde from your link.
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform