I did find 2 errors with the ado object and rs object, "set" oConnection = "server."createobject. So now I have the connection.
But now I am kinda of stumped, the error is:
"[Microsoft][ODBC Visual FoxPro Driver]File 'agencycodes.dbf' does not exist"
I know the table is there. Is it not seeing it or does not recognize it as a free table?

>I'm not seeing an error with your script. Does the error message return a line number identifing the line of code that generated the error?
>
>>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: ''