ODBC architecture constitutes six major components namely
Front-end Tool : This provides an interface to access the database residing on back-end server, and also to present the information to the user in the format specified.
Back –end DataBase engine : this is responsible for storing, retrieving, and maintenance of data.
Database : Database is a set of data items that are logically related. A database is just a storage scheme of data, which can be manipulated only through the corresponding database engine.
ODBC Driver : Every database engine will have only one ODBC Driver. This is usually supplied by the database vendor.
ODBC Data Source : ODBC Data Source provides the way for a front-end to connect to a data source.
ODBC Manager : To manage ODBC Drivers and ODBC Data Sources, a program is supplied along with the database or sometimes with the OS which is called ODBC Manager. This can be used to install new ODBC Drivers or create new Data Sources.
Posted Date:- 2021-10-12 07:30:02
Why JDBC is needed once we have ODBC in hand?
Explain ODBC its Architecture?
How EJB Container handles exceptions?
What is Application level Exception in EJB?
What is Bean Managed Transactions?
What are the types of Enterprise Bean?
Which types of java classes can be mapped using @Lob annotation?
What are the different JDBC driver types?
What is enterprise information system?
What is Enterprise JavaBeans Query Language?
What is enterprise bean provider?
Define the term DDL, DML and DCL in Database Connectivity?
What is a Stored Procedure in JDBC?
What are the different properties of a Java Bean?
When will JavaBeans be supported on the [fill in the blank] platform/operating system?
What are the security implications for downloading Beans over the Internet?
Why do I get a duplicate name error when loading a JAR file?
What is the relationship between Sun s JFCs and JavaBeans?
Why nobody at Sun wants to read the messages sent to java-beans@java.sun.com?
Are there JavaBeans components available that I can buy today?
What kind of industry support exists for JavaBeans?
Why a component architecture for the Java platform?
Is JavaBeans a complete component architecture?
Is JavaBeans a complete component architecture?
Why are component architectures useful?
What is a Bean? Why is not a Bean an Applet?
Difference between java bean and bean?
What is property editor in java beans?
What are externizable interface?
What is bean persistance property?
Why do I get a NullPointerException when loading a JAR file into the BeanBox?