it's desired to have one single database in organisations, but there exist more than one applications - in fact there are multiple applications in organisations which access the database and draw data when they need it.
Applications in order to access the database need a connection, this connection of course can be established in many ways. ODBC aims to provide a standard way using SQL to connect different applications such as MS Access, MS Excel, dynamic web pages or other applications such as data mining tools (e.g. WizRule). So if applications want to get data which doesn't exist on their HDD, first they need connect to the relevant database, ODBS provide this connection; once this connection is established any application can access to the database without establishing the connection again. So the connection is only established once but depending on the setting of the system authentication is required.
As said ODBC access database by SQL which is a DBMS language for programing and structuring language.
According to Wikipedia ODBC includes two parts:
1. the driver manager which works as an interpreter between database & applications.
2. the database driver which includes details of the database itself.
fist written on: July 14, 2008
No comments:
Post a Comment