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?

 

[philhege]

Hi Kevin,

The bottom line, and I got this straight from the MS PSS horse's mouth last winter, is "we don't support data manipulation through the link server and VFPOLEDB." Select, yes; I/U/D no.

What we did is an ugly workaround, but works nonetheless: we have a work table which holds the table and key of the data needing update. We call a FoxPro executable through xp_cmdshell that connects to SQL, reads the work table, and updates the Fox tables with the SQL data through cursor scatter/gather operations.

Good luck.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.

 

[KevinPublic]

Okay... ICK. Thanks for the info!