VFP Linked server problems

[KevinPublic]

We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0. I need to make some costing adjustements from our inventory program. I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch. Performing an UPDATE or INSERT, however, is a different story. I get the following error:

"Server: Msg 7301, Level 16, State 2, Line 1
Could not obtain a required interface from OLE DB provider 'VFPOLEDB'."

I was told to get the latest OLEDB provider for VFP and install it. I did. I rebooted the machine, deleted the old linked servers and re-created one. When I try to look at it through the Entperprise Manager of SQL Server, I get this error:

"Error 7373: Could not set the initialization properties for the OLE DB provider 'VFPOLEDB'."

Can anyone help me?

 

[Mike Lewis]

Kevin,

I can't answer your specific question. If you don't get an answer here, you might try asking in one of the SQL Server forums, as the problem might lie in the use of linked servers rather than being related to the VFP OLE DB provider.

If you don't solve the problem, you could consider attacking it from the other direction, that is, write some VFP code to access SQL server, rather than the other way round.

Many people here have had experience of doing that, and should be able to help.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)