Explain The Components Of Odbc Architecture?

1.	Explain The Components Of Odbc Architecture?
Answer» APPLICATION – any front end/GUI from where ODBC calls are made. Driver Manager – it is a DLL that CONTROLS loading of appropriate drivers to connect to DBMS. When an ODBC call is made, it scans the .ini files to determine which driver to use. Driver* – it is the heart of ODBC that takes CARE of N/W protocols to connect to the data source; it also submits SQL statements to the data source. RDBMS – an ASCII file containing information such as DBMS name, login/password etc. ODBC takes care of LOCATING the Sybase/SQL server address on the network by reading the win.ini/sql.ini files. ODBC takes care of locating the Sybase/SQL server address on the network by reading the win.ini/sql.ini files.

Answer»

APPLICATION – any front end/GUI from where ODBC calls are made.
Driver Manager – it is a DLL that CONTROLS loading of appropriate drivers to connect to DBMS. When an ODBC call is made, it scans the *.ini files to determine which driver to use.
Driver – it is the heart of ODBC that takes CARE of N/W protocols to connect to the data source; it also submits SQL statements to the data source.
RDBMS – an ASCII file containing information such as DBMS name, login/password etc.

ODBC takes care of LOCATING the Sybase/SQL server address on the network by reading the win.ini/sql.ini files.

ODBC takes care of locating the Sybase/SQL server address on the network by reading the win.ini/sql.ini files.

Discussion