Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get remote data without using ODBC ???
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00408172
Message ID:
00408341
Views:
17
For further info.....I did get ADO working without an ODBC configuration by using vfpcom.comutil and RstoCursor to display the data retrieved. The information I was missing was the "SourceType" property. Where is the documentation located for that property?

For anyone interested, this is the code:

oAdo=createobject('vfpcom.comutil')
oRs=createobject('adodb.recordset')
oRs.cursortype=3
oRs.Locktype=1
oRs.cursorlocation=3
oRs.open('select * from dispdiv',"driver=Microsoft Visual FoxPro Driver;sourcedb=r:\genserv\recmgmtv6\;sourcetype=DBF;")
nErr=oAdo.rstocursor(oRs,'hold')
if nErr <> 0
messagebox('RecordSet cursor not available',0,'')
else
brow
endif
Extreme Programming = Plan -> Design -> Code -> Test
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform