>Hello all,
>
>I'm in the process of selecting the right platform to develop a three tiered system. Following, I'll give a short description of the system and what my options are.
>Here's my platform selection
>
>Client tier: Visual FoxPro
>Business rules tier: Microsoft Transaction Server (MTS)
>Server tier: SQL Server 7
>Off-line Server tier: MSDE (SQL Server compatible data engine)
The above should handle your requirements... but, as has been said... MTS is NOT what you will build your Middle Tier with... it is an environment to run it in.
And, actually, the above is even getting old school... the new way being:
Client Tier: Browser (DHTML or Java served from next tier.)
Presentation Engine: IIS - (DHTML is built here using ASP or ISAPI application like Web Connection)
Business Rules: VFP COM Object(s) (With Web Connection the Business Rules and Presentation Code is generally in the same EXE, but doesn't have to be.)
Data Tier: SQL-7
THere is alot of info on building these kinds of aps on
www.west-wind.com... You'll also find article about Large Scale Web Development... which you could thing of as n-Tier ap... which basically is what a Web Ap is... an n-Tier program.
Good luck to ya!
BOb