![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Explain Single and multi-tire architectures of ODBC?
Generally, ODBC architecture is of two types single-tier and multi-tier.
Single-tier architecture
This is an ODBC architecture which involves single-tier ODBC drivers. In singletier ODBC architecture, the ODBC driver receives ODBC requests/calls from the application and directly interacts with database files. It passes the SQL commands corresponding to the received calls and retrieves the results.
Example: Microsoft Access
Multiple-tier architecture
This is an ODBC architecture which involves multiple-tier ODBC drivers. This is a common architecture and is based on client server communication.
Client: The application that makes ODBC requests, the driver and the DriverManager together considered as a client.
Server: The database and the database software (that provides DB access) together are considered as a server.
In ODBC multi-tier architecture, the application sends ODBC request/calls to the server and the server holds the ODBC calls and passes the SQL statements to the database system.
Example: Oracle, SQL server.