Cetin, I too am trying to setup a conection to my vfp tables from VS net but wonder if the odbc driver has to be on the server?



>>Hi All,
>>I am trying to connect to my VFP data using OLEDB in ASP.NET
>>
>>

>>Conn = New System.Data.OleDb.OleDbConnection("provider=VFPOLEDB.1; data source='" & MyDataSource & "'")
>>Conn.Open()
>>

>>
>>Then here's what I get:
>>
>>

"Non-NULL controlling IUnknown was specified, and either the requested interface was not IUnknown, or the provider does not support COM aggregation."
>>

>>I tried in the other server with exactly the same settings/configurations and it is ok.
>>Any Idea?
>>
>>Thanks
>>
>>Jay
>
>From an ASP this works for me just right:
>

>    dbpath = Server.MapPath("data")
>' ADO connection ...
>  .ConnectionString = "Provider=VFPOLEDB;data source=" & dbpath & "\myDatabase.dbc"
>

Cetin