VFP vs SQL Server 1

[itflash]

Hi

Is VFP a viable alternative to SQL Server?

Could I develop VB ASP to query a VFP database and put it on the web, or would it be too slow or not be able to handle multi-user?

I tried this once with MS Access and it did not work.

Am I asking a stupid question? ;-)

Cheers.

 

[ramani]

VFP cannot be an alternative to SQL server. VFP can be a front-end. VFP can work with others such as VB and it belongs to VISUAL STUDIO family. VFP7 is released separately from VSTUDIO, but it will continue to work with that. VFP can work standalone as well without SQL. It depends on the size and convenience. The security is surely better with SQL. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[foxdev]

Itflash, you can use VFP as a Web database server using various techniques (for example, you could connect to it from ASP via ADO, or you could use FoxISAPI to interface to a VFP program). Naturally, you can use ADO to connect to SQL Server as well.

At some point, scalability becomes an issue, but probably not for the size of site you are considering.

See

http://www.west-wind.com

for additional information on using VFP as a Web database server. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[itflash]

Thanks for the replies. Maybe some more info?

I have developed a VB ASP SQL Server Web site before on an NT Server. This was fine and was for loads of users.

The possible solution I am looking at is a web site with 20 possible users connecting to it daily. I was wondering if I could get away from purchasing SQL Server and just go directly into FoxPro using ADO/ODBC. I only want to do some reporting in the first instance.

Regarding security, I'm sure I could get some other security on the site.


foxdev (Robert), you said it was possible whilst ramani didnt seem to think it was a good idea.

When I tried it with MS Access, it did not like multi-users connecting to the site and would hang. Would Foxpro be the same? Has anyone else done something similiar?


Thanks again for your replies

 

[foxdev]

Rick Strahl of West-Wind is the king of VFP Web sites, so you really need to check out his site. There are several methods or models that could be used, including ISAPI (which I believe Rick prefers, for performance reasons). ASP is another option (look for the topic AFP-Active FoxPro Pages).

A must-read: Rick's article here:

http://www.west-wind.com/presentations/aspobjects/ASPObjects.htm

I've never built a VFP-based Web-connected database or program, so take what I say with a grain of salt. All of my Web database experience is MySQL (2%) and MS SQL Server (98%). Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[ChrisCarroll]

Would it be fair to say that for non-web applications:

Access is good for about 5 or 6 simultaneous users (I think I got that from MS somewhere)

FoxPro for 50 - 250 (depending on just how simultaneous - 250 users is about biggest pure FoxPro system I've worked on)

and SQL server will take you further if your system is big enough?

And that Rick's article kind of implies that 20 users should be fine so long as you have VFP6 with SP3 installed?