What is ODBC?

  1. Home
  2. Knowledge Base
  3. GMS
  4. What is ODBC?

Answer

Abbreviation of Open DataBase Connectivity, a standard database access method developed by Microsoft Corporation.

The aim of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver, between an application and the DBMS.

The purpose of this layer is to translate the application’s data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant — that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them.

Since version 2.0, ODBC supports the ANSI Standard SAG SQL.

Gordano products are ODBC Compliant.

NTMail can authenticate users via the SQLAUTH.DLL provided in the option pack. Firstly you will need to setup a DSN in control panel > ODBC and tell the sqlauth.dll which DSN to use for authentication.

GlCommunicator can store all of its membership information in an ODBC database, and can also work with existing in house ODBC databases to allow companies to leverage their existing customer information.

Keywords:ODBC database

Was this article helpful?

Related Articles