VFP8 & SQL Server 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sp - 13 Jul 2004 21:08 GMT

We want to deploy our VFP8 application in our customer machines and we would
like to keep the data in our SQL Server 2000. How easy or difficult to make
our application fetch our SQL Server data over the internet?

sp

Reply to this Message

Gerben Kessen - 13 Jul 2004 21:33 GMT

Hi sp,

A good option is to make a simple Foxpro webservice, which is the mediator
between SQL server and the client on the other site of the internet.
Of course your data will be transported over the internet in XML.

Hth,
Gerben Kessen

> We want to deploy our VFP8 application in our customer machines and we would
> like to keep the data in our SQL Server 2000. How easy or difficult to make
> our application fetch our SQL Server data over the internet?
>
> sp

Reply to this Message

Lee Mitchell - 13 Jul 2004 22:26 GMT

Hi SP:

Here are examples of creating a web service like Gerben mentioned:

321512 How To Call a Visual FoxPro 7.0 Web Service from ASP
http://support.microsoft.com/?id=321512

307355 HOW TO: Call a Web Service in Visual FoxPro 7.0
http://support.microsoft.com/?id=307355

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hi sp,

>A good option is to make a simple Foxpro webservice, which is the mediator
>between SQL server and the client on the other site of the internet.
>Of course your data will be transported over the internet in XML.

>Hth,
>Gerben Kessen

> We want to deploy our VFP8 application in our customer machines and we
>would
[quoted text clipped - 3 lines]
>
> sp

Reply to this Message