>>Hello all
>>
>>I am trying to connect to a VFP database using asp to get some data out of it to insert into my SQL server.
>>
>>Here is the Code:
>>
>>
>> Set oConn = Server.CreateObject("ADODB.Connection")
>> oConn.Open "DSN=DATA;" & _
>> "Uid=IUSR;"
>>
>>
>> SQLquery = "SELECT * FROM CUSTOMER"
>> Set RS = Server.CreateObject("ADODB.RecordSet")
>> Set RS = oConn.execute(SQLquery)
>>
>>Here is the result:
>>
>>
>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
>>[Microsoft][ODBC Visual FoxPro Driver]File 'customer.dbf' does not exist.
>>
>>I know for a fact that the file exsists and that the proper permissions are assigned
>>
>>The reason for the asp is that this process needs to automated i need to able to automaticaly get the data from one database into another with out any user interaction and i also need in prevent duplicate data from being inserted into the datase.
>>
>>Can anyone tell me what I an doing wrong, or possible provide another solution.
>
>Why not build a COM object to accomplish what you are doing. You could use a local view to pull the data from VFP, and then insert the data into SQL server with any mechanism that best suites your needs.

A COM object would be an easier approach, I think, as you can use native VFP commands. But in the case of the example, I'm no expert but I would try including the file path if you're not already doing so.

Aloha,

James