What is an ODBC compliant database?
ODBC, short for Open Database Connectivity, is a standard database access method developed by the SQL Access group in 1992. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system is handling the data.
In layman's terms, an ODBC compliant database is simply a type of software that uses ODBC in order to be able to exchange information with other unlike databases. This standard is now being used by a wide variety of different and commonly used programs.
Some examples of common ODBC compliant databases are:
- Microsoft Access
- Microsoft SQL Server
- Microsoft Visual FoxPro
- IBM DB2
Since the use of ODBC is so common, there are also a number of other database products that use ODBC in addition
to the list above. If you are using a database program, it is very likely to be ODBC compliant.
If you don't see your database software on the list above and are unsure as to whether or not your database software is ODBC compliant, check your manual or contact the database software developer.