Essay Zone.com - Free essays!
REGISTER NOW!
Login to an existing account
     
GCSE essays
A Level essays
University essays
Forum
Why join?
Essay quality
FAQ

Search forums
About us
Contact us

 

 
Database connectivity Free essay! Download now

Home > A Level > Computing > Database connectivity

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: N/A | Words: 2095 | Submitted: 04-Jan-2012
Spelling accuracy: 96.0% | Number of pages: 17 | Filetype: Word .doc


This is what the first 3 pages of the essay look like

Database connectivity essay previewDatabase connectivity essay previewDatabase connectivity essay preview

Description

About connecting to databases

Preview

Table of contents

Pages
Introduction 3
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
Conclusion 15
References 16



INTRODUCTION

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)
IBM i7.1
Microsoft Data Access Components (MDAC)
unixODBC


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

Or you can download this essay for $2 immediately without registering


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.