asked on

Can Sharepoint access

Can Sharepoint access Visual Foxpro 9.2 tables and data containers. We are looking ot Sharepoint only to INPUT data, not process it (The Foxpro program will do that). We will add the data to a table, then Foxpro will process.

Any opinons or suggestions are appreciated.

Frank

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ivan Padabed

good answer from pcelba, I would add some points: you can use workflow to propagate your data to FoxPro, you need to implement custom WF action for SPD WF or implement entire WF in MSVisual Studio. Another alternative is event receiver with this logic, it depends on when you want your data be sent to foxpro.

fmoore0001

ASKER

pcelba

Thanks, you got me on the right track.

jinfeld

Other than the Layer2 product (listed above), is there a way to use SharePoint Services 3.0 to do real-time read-only access to VFP 8 or VFP 9 data tables or DBC views? The other links above, point to SharePoint 2007 solutions.

Pavel Celba

VFP OLE DB provider always connects data in real-time, it does not use any copy.

So, if SharePoint Services 3.0 support OLE DB data access then you should be successful. (Just FYI, SQL Server 2008 32 bit edition can create Linked server and access FoxPro data concurrently to running Visual FoxPro application.)

I don't know more details and you should probably ask new question in SharePoint zone to become visible by more experts (old questions are not monitored obviously).