MTS 1

[rajeevnandanmishra]

Is it possible to get the benefits of MTS while using VFP 6.0 and SQL 6.5?
I am having a foxpro client with sql back end. If we run application from local sites (where sql server is in same LAN) it is fine. But when we run it from a remote location it gets burned. I had heard about doing the same using VB. But how to do same in VFP?
From where i can get descriptive help for this.

 

[ramani]

In your code you have started a BEGIN TRANSACTION and ended with a COMMIT rather than END TRANSACTION...

In VFP .. BEGIN TRANSACTION loop shall end with END TRANSACTION. COMMIT is auto completed when the END TANSACTION is issued, otherwise the TRANSACTIONS are still accumulated and you could end up in error next time the same loop starts another transaction.. and soon an error situation with VFP getting into too many loops.
Hope this helps you. If this is not what you are looking for, just ignore it. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[jonscott8]

Microsoft Transaction Server for Visual FoxPro Developers
http:// msdn.microsoft.com / library / techart / Mtsvfp.htm

Yes, if your backend is SQLS, as you indicate. But IIRC, VFP database transactions (those performed on dbfs) do not support the necessary transaction protocol (Distributed Transaction Coordinator) to be managed by MTS.
And, IMHO, I dont think database transactions under VFP7 will managable by COM+ either, but maybe someone else with VFP7/COM+ experience can dispute/confirm that.

What do you mean by "But when we run it from a remote location it gets burned"? Jon Hawkins

 

[rajeevnandanmishra]

Thaks jonscott8,

The problem i am facing is when i run my foxpro exe to connect to a remote server (via wan) it simply stucked up. A lot of time it gives me an error "connection time out". I know a few of my friends who are working in VB. They used MTS as the middle tier. And it smooths up the work tremendously.
So, i want to know, if i can use MTS in VFP also. If yes, HOW?

 

[jonscott8]

http://msdn.microsoft.com/library/techart/Mtsvfp.htm

Sorry, I dont know what happened to the above url I posted. Somehow it got spaces embedded in it. Jon Hawkins

 

[rajeevnandanmishra]

Thanks Jon, I got that url correctly and had gone through it. It specifies the way one could write VFP server codes in MTS. Whereas i am just interested in VFP client application. I don't want to create VFP com+ Objects or DLLs.

By the way, thanks again for your URL. It was really a nice document for the new person like me in MTS.