SQL Linked Server with FoxPro

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello I have configured a Linked server with FoxPro in SQL Server. When I use
Query Analyzer on the server I can select data from the FoxPro table, but
when connecting to SQL Server from a c# application and executing a store
proc that return data from the FoxPro data base I get the following error:

Could not initialize data source object of OLE DB provider 'VFPOLEDB'.

SQL Server is running in the LocalSystem Account. I have tried to change it
to the domain admin account. But by doing this I'm no longer able to select
data from the FoxPro database from Query Analyzer.

How can I make this work?

Thanks, Michel
.

Relevant Pages

  • Re: data provider
    ... using the foxpro OLEDB route does the end user have to have Sql Express ... There are two ways to procede to get VFP data into SQL Server Compact ... these are the OleDb data providers: ...
    (microsoft.public.sqlserver.ce)
  • Re: data provider
    ... provider that your Foxpro app will use. ... When I talk about a sdf file in my mind its a SQL Server Compact edition ...
    (microsoft.public.sqlserver.ce)
  • Re: data provider
    ... provider that your Foxpro app will use. ... When I talk about a sdf file in my mind its a SQL Server Compact edition ... create a SSCE database that contains all of my tables ...
    (microsoft.public.sqlserver.ce)
  • Re: help with conection between SQL server & DBF file with cdx index. thanks
    ... To move the data into sql server, you likely don't want, or need to use ... consider at least linking to the Foxpro tables, ... Originally posted by Cindy Winegarden Microsoft Visual FoxPro MVP: ... Start with the latest ODBC driver for FoxPro and Visual FoxPro, ...
    (microsoft.public.access.externaldata)
  • Re: SQL Server vs. Foxpro
    ... I used to use Foxpro for small apps, ... There are many more tools available which can use data in SQL Server ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > My company has recently "merged" with another company who uses Foxpro as the> backend for their ASP front end. ...
    (microsoft.public.sqlserver.server)