Overview
As organizations expand, they often acquire a mixed collection of computers, networks, and databases. To be successful in a fast-paced economy, data must be presented swiftly and reliably by using applications that reach across a network of workstations, servers, and legacy mainframe systems and that bypass geographic boundaries. Microsoft SQL Server 7.0 offers a powerful solution based on Universal Data Access (UDA) architecture, implemented by means of OLE DB. With this approach, information no longer needs to be funneled into a single data store and instead can be presented directly from many sources, without having to be migrated or converted. This downloadable document explores scenarios based on transparent data access techniques using the UDA architecture of SQL Server 7.0. It also outlines strategies for designing resilient, scalable business systems applications with Microsoft Transaction Server.

Included in this document:

• SQL Server 7.0 for the Heterogeneous Environment
• SQL Server 7.0 in an Oracle Environment
• Data Access
• Microsoft Transaction Server