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