>Thanks a lot, It worked. Now I am facing the other challenge > >It works with ODBC. Now I want to link the dbc with OLEDB provider for Visual Foxpro > >I already install the oledb provider but I just can't get the data. any Ideas?
Did you install and register the VFPOLEDB.DLL on the SQL Server machine?