www.cryer.co.uk
Brian Cryer's Web Resources

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.