I am currently supporting a VERY LARGE application in Visual Basic 5.0. We use Access as our scratch pad and Sybase as our main Database.

Here is the problem. I am currently ripping the app apart in to an N-Tier application with COM objects for both Business Logic and Data Access.

I am looking into using Microsoft Transaction Server to host the COM objects. Can MTS work with Sybase Adaptive Server Enterprise 11.9.2? Can MTS use it's Transaction processing with Sybase?

Any suggestions?