Is Interoperability Achievable With ODBC

Open Database Connectivity (ODBC) is a call level interface to databases. In contrast to Embedded SQL and PL/SQL, programs using ODBC are meant to be database independent. This is achieved by an additional layer between the application and the database. In this paper we regard interoperability not as the question if it is at all possible to work with different DBMS''s (database management systems) but how easy and convenient it is. We will show that there are some deficiencies in the design of ODBC which reduce the degree of interoperability but also that these can be remedied with moderate effort.