The ODBC interface defines the following:

Ø A library of ODBC function calls that allow an application to establish connection to a database environment and execute SQL statements

SQL syntax, as per the standard

Ø A standardized set of error codes

Ø A standard way to connect and log on to a database environment

A standardized representation of data types

          This standard interface offers the following advantages for applications:

Can construct SQL statements at compile time or run time

Ø Can use the same object code to access different database environments

Ø Can connect to multiple database environments simultaneously

Ø Can ignore data communication protocols associated with a database environment

Ø Can send and receive data in a format convenient to the application

                ODBC being a call interface, no pre-processing of programs is required. It is also devoid
                of the restrictions and clumsiness of using embedded SQL.