How to connect to a datasource 1

[GKBray]

Hi,

Can anyone tell me how to get sharepoint services to read in data from a external database, namely VFP.

My Server has all the relevant ODBC entries, but I don't know where to start.

Many thanks in advance.

G Bray

G K Bray Programmer

 

[PatricktheAnalyst]

Having worked with several small vfp applications and sharepoint, I thought that the easiest way was to use SQL reporting services and the Reporting services web parts for displaying information.

How tightly do you need the data to be integrated?

Thanks!

Patrick

 

[GKBray]

Hi Patrick,

I would like to be able to display a filtered list of records, from various tables, and possible use info path to create some dynamic forms to feed data back to VFP.

Thanks

Graham

G K Bray Programmer

 

[PatricktheAnalyst]

Moving data into foxpro should be easy, just create a view of the userdata table that is filtered for the appropriate listid. I would not try going the other way (creating new records in sharepoint from vfp) but I have used this with a simple odbc link to modify records.

Thanks!

Patrick