|
 Home
FAQs
News
Request Form
Post Resume
Web Request
Job World
Comments
Quote of the
day:
If someone betrays you once, it is his
fault;
If he betrays you twice, it is your fault.
|
What is ODBC?
Open Database Connectivity (ODBC) is a driver that you can use to
access data between two different programs. Microsoft Transaction
Server and ODBC provides the following benefits:
- Database connection pooling.
The system maintains a pool of preallocated database
connections. When an application component opens a database
connection, the system locates a free connection in the pool and
allocates it to the component. When the application closes a database
connection, the connection is returned to the pool. This makes opening
and closing database connections faster and less expensive.
- Automatic transaction enlistment.
When a transactional application component opens a
database connection, Microsoft Transaction Server automatically
enlists the database connection in the component's current
transaction. This makes application development easier. The
application benefits from transactions with less application
programming.
- Transparent access to databases on Windows NT®, UNIX, and other
platforms.
An application can update databases residing on Windows
NT, UNIX, IBM AS/400, IBM MVS, Tandem, and other systems. The location
of the database is transparent to the application developer. This is
possible because the application opens a database connection by
specifying an ODBC DSN. The DSN specifies the name and location
of the database. The DSN permits the application located on the
Windows NT-based system to transparently communicate with databases
distributed across a wide variety of platforms.
- Distributed transactions.
All of the databases an application accesses can be
updated under the control of a single atomic transaction. If the
transaction commits, all of the application's updates are made
permanent in all of the databases. If the transaction aborts, all of
the application's updates are rolled back in all of the databases.
This is true even when the databases are distributed across a
collection of Windows NT, UNIX, IBM AS/400, IBM MVS, Tandem, and other
systems.
Back to Top
|
