Replace lines 2 and 3 with:
oConn.Open "DRIVER={Microsoft Visual FoxPro Driver};SourceDB=g:\FRED;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;"
Note the SourceDB parameter. This will need to be modified to your situation. The method above is for connecting to free tables in the g:\fred directory. Any table reference in a SQL query will need to be a dbf in that directory.
If you want to use a database container as the source then add the DBC file name to the SourceDB e.g. SourceDB=g:\fred\almis.dbc. Then change the SourceType parameter from DBF to DBC. Then ADO will use the container to determine where the table files are.
HTH
>Does anyone know where I can find the syntax for asp? I would like to convert the code below to connect to a VFP table rather than an access table (database).
>
>1 set conntemp=server.createobject("adodb.connection")
>2 cnpath="DBQ=" & server.mappath("yourtable.mdb")
>3 conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
>4 set rstemp=conntemp.execute("select * from authors")
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
