I found some code that works from VFP. When I put it in an asp page is does not work. This is the code and error:
Code:
DIM oConnection, lcConnectionString, oRecordSet
oConnection = CreateObject("adodb.connection")
lcConnectionString = "Driver=Microsoft Visual Foxpro Driver; "_
& "UID=;"_
& "SourceType=DBF;"_
& "SourceDB=U:\Personnel\Source\Reassign_v1.00\Data"
oConnection.open(lcConnectionString)
oRecordSet = CreateObject("adodb.recordset")
oRecordSet.Open "SELECT * FROM agencycodes", oConnection
Response.write oRecordSet.fields(1).value ' Alfred's Futterkiste
ERROR:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
Extreme Programming = Plan -> Design -> Code -> Test