ODBC

1
ODBC

• ODBC stands for Open Database Connectivity
• Its purpose is to present a database-independent
  method for accessing databases
• ODBC consists of a set of drivers which
  facilitate exchange of information between an
  application and a database.

2
ODBC

• To configure ODBC, open ODBC data source in
  Windows Control Panel

3
ODBC

• One of the ways Client Applications use ODBC to
  connect to a Database is by referencing a stored
  collection of connection information called a
  data source name (DSN).
• A DSN contains information about the server name,
  the user login, password and a default database.

4
Types of DSNs

• User DSN restricted only to the current user
• System DSN- is available to all users on the
  network
• File DSN-information is stored in a separate file
  and available to all users

5
Creating a New DSN

• Click the Add button
• Select the ODBC driver you want to use and click
  finish.
• The list includes drivers for Oracle, Access, SQL
  Server etc.

6
Creating a new DSN

• To connect to an Access database select the
  Microsoft Access Driver
• Select the Access database and enter a DSN name
  and press ok

7
ODBC

• The new DSN will now be listed.

8
ODBC

• DSNs can be used in a variety of Application
  Development environments including
• Visual Studio (includes Visual Basic, Visual
  InterDev, Visual J)
• In Java which uses another protocol called Java
  Database Connectivity (JDBC) to communicate with
  the ODBC drivers.