What is ODBC?

ODBC stands for Oracle Database Connectivity. It is an API which is used to access different databases.

The OFBC driver uses the Open Database connectivity interface provided by Microsoft to communicate with the databases. It is independent of Databases and platforms and operating systems. Once you develop an application using ODBC you can run it on other platforms with little change in Data access code. ODBC uses SQL syntax and it is based on Open call level interface.

Nancy Den

Published on 19-Mar-2019 10:29:18

• Related Questions & Answers
• What is the difference between ODBC and JDBC
• What are the features of ODBC?
• What are the important components of ODBC?
• What are the disadvantages of ODBC drivers?
• Explain the ODBC architecture?
• Difference Between JDBC and ODBC
• Difference between ODBC and JDBC in Java
• Explain Single and multi-tire architectures of ODBC?
• How to connect to SAP database using ODBC driver
• What should I prefer to connect to SAP HANA database- extended services or other ODBC technique?
• Different ODBC connection types under SAP HANA Smart data access SDA
• Disabling JDBC/ODBC access to SAP HANA system for a new user
• What is Java API and what is its use?
• What is DatabaseMetaData in JDBC? What is its significance?
• What is ResultSetMetaData in JDBC? What is its significance?