Database connectivity Free essay! Download now
Home > A Level > Computing > Database connectivity
You can download this essay for free. All you need to do is register and submit at least one of your essays to us.
Or you can purchase this essay for just $2 instantly without registering
Downloads to date:
| Words: 2095 | Submitted: 04-Jan-2012
96.0% | Number of pages: 17 | Filetype: Word .doc
This is what the first 3 pages of the essay look like
DescriptionAbout connecting to databases
Table of contents
1. Implementation of database connectivity 4
1.1 independent open database connectivity 4
1.2 IBM i7.1 6
1.3Microsoft data access component 6
1.4 unixODBC 6
Bridging Configuration 7
2.1 JDBC-ODBC bridges 8
2.2ODBC-JDBC bridges 14
A database connection is a facility that allows client software to communicate with database server software, whether on the same machine or not. A connection is required to send commands and receive answers. Connections are built by supplying an underlying driver or provider with a connection string, which is a way of addressing a specific database or server and instance as well as user authentication credentials. Databases, such as PostgreSQL, only allow one operation to be performed at a time on each connection. If a request for data (a SQL Select statement) is sent to the database and a result set is returned, the connection is open but not available for other operations until the client finishes consuming the result set. Other databases, like SQL Server 2005 (and later), do not impose this limitation. However, databases that provide multiple operations per connection usually incur far more overhead than those that permit only a single operation task at a time. In this presentation, we will be focusing on the Open Database Connectivity (ODBC). Open Database Connectivity (ODBC) is Microsoft's strategic interface for accessing data in a heterogeneous environment of relational and non- relational database management systems. Based on the Call Level Interface specification of the SQL Access Group, ODBC provides an open, vendor- neutral way of accessing data stored in a variety of proprietary personal computer, minicomputer, and mainframe databases.
Sourced at http://support.microsoft.com/kb/110093
IMPLEMENTATION OF DATABASE CONNECTIVITY
Database connectivity can be implemented through various applications such as:
Independent Open Database Connectivity (iODBC)
Microsoft Data Access Components (MDAC)
1.1 Independent Open Database Connectivity (iODBC)
iODBC is a driver manager and is regarded as open source initiative that manages and establishes access to ODBC drives. The iODBC is succinctly coordinated by Open Link Software and makes use of two different files for configuration, these files are;
odbcinst.ini: this file gives a detail description of the drive; example of this file is ODBC-ODBC bridge client server or the free TDS ODBC driver.
Odbc.ini: this file, gives a description of the source of the data (data source: the particular database instance to connect to)
The two reasons for using an ODBC
Availability : ODBC has Portable Data Access Code feature which makes it available on all main ...
Download this essay in full now!
Just upload at one of your essays to our database and instantly download your selection! Registration takes seconds
Comments and reviews
Reviews are written by members who have downloaded the essay
No comments yet. If you download the essay you can review it afterwards.