|
ODBC stands for "Open Database Connectivity", and is
a method created by the " SQL Access Group" to provide
access to data in any standard database regardless of the management
system used by the database. It manages to perform this by using
a middle layer database driver that works between the database application
and the management software. ODBC can become complex for large organisations
with thousands of computers, so to simplify their administration
problems server technology has been developed. The only requirement
is that the database application must be "ODBC compliant".
ODBC has been implemented on the majority of popular operating systems,
such as Unix, Windows, Linux, IBM's OS/2, and Mac's OS X. The majority
of major database applications like Oracle, Microsoft SQL Server,
Sybase, MySQL, and FileMaker have developed their own versions of
a ODBC. Some of these are open source and others like Microsoft's
are closed set of DLLs.
|