Can Sharepoint access

Posted on 2010-01-04
Medium Priority
Last Modified: 2012-05-08
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.

Question by:fmoore0001
LVL 43

Accepted Solution

pcelba earned 2000 total points
ID: 26176953

Expert Comment

by:Ivan Padabed
ID: 26191088
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.

Author Closing Comment

ID: 31672725

Thanks, you got me on the right track.

Expert Comment

ID: 34551302
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.
LVL 43

Expert Comment

ID: 34555220
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).

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Screencast - Getting to Know the Pipeline
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question