frontend/backend

[sermac]

Hi: Newbie here, and thinking about getting MS SQL server 2000 as a backend database, does it have a frontend that is OOPS, like VB or VFP(. . .currently built my "in house" project in VFP with 1-m and m-m, views and sqls, etc.)looking to network within our company. . .)or shd I stick with my VFP and connect it to SQLserver2000?
Any feedback would be deeply appreciated.
THX
Bill

 

[NoCoolHandle]

Front end can be anything...

VB,ASP,JSP,VFP,ACCESS,C%....

You might find just changing the datasource in Foxpro is enough.. That could provide you with a very fast change over.

What I am not sure of is how FoxPro will internally handle database connections and specificly recordsets/cursors. My momory of foxpro is that it tends to do alot of locking at the table level, which is why it starts to have problems in multi user environments.. My guess is that SQL should not suffer from those problmes, but you might want to test that carefully.

I tend to program in VB/VB.NEt and ASP/ASPX.. But there should be no real problems with Vfoxpro as a front end in my understanding. (I did a 1 week course once but never did any real work in it so just don't know for sure)