ODBC
- ODBC
- Open Database Connectivity. Open standard developed by Microsoft aiming to provide a
consistent interface to relational databases regardless of which database engine is used
(e.g. SQL Server, Oracle or MySQL). In theory to migrate to another database should only
require the installation of the appropriate ODBC driver for the new
database.
Whilst ODBC does successfully address many of the issues involved in migrating from one database to another, there are issues outside the scope of ODBC which can (for some applications) have serious implications when migrating databases.
See also DSN.
For more information see:
- www.unixodbc.org - Homepage for the unixODBC project, which promotes unixODBC as a standard for using ODBC on UNIX. Site provides information and downloads.
- www.datadirect.com - company that sells ODBC drivers.