Hi Chetan,
>We are upgrading our MRP Product, currently on FoxPro 2.6 Dos to client server using VFP 5.0 and SQL Server 6.5. We are still in the design stage and we wish to incorporate all the latest FoxPro features in the new upgrade. Like MS Transaction Server and COM/DCOM.
Don't jump into a technology simply because its the latest buzzword. Figure out wether you require Transaction server or not. Developing a Client-server application and using a transaction server as a middle ware is contradicting.
VFP works very well with SQL Server. A good start would be to use parameterized remote views. There are lots of frame works available which reduce the effort for initial developement.
Kamal