FreeTDS Development Group

["Geoff Winkless" <geoff AT farmline.com>]

"Lowden, James K" <LowdenJK AT bernstein.com> wrote:
: Of course, if you build a layer in your system and call it a "middle tier"
: that provides data services to the application and speaks SQL to the
server,
: you can say your application is portable.  But that "middle tier" just
: isn't, stored procedures or no.

What??? A true "middle tier" means that neither side cares (or knows!) about
the structures or communications layer used by the other side. As such, if
you change the database, the majority of the code will not need to be
changed, merely the middle tier.

A well written middle tier should be reasonably portable. A middle tier that
relies on implementation-specific SQL will (of course) present the same
problems.

Geoff