User`s guide

Configuring a Driver and Data Source
2-13
Configuring a Driver and Data Source
Connect to a database and interact with the data by first installing the driver for the
database. Then, define a data source for ODBC or add the full path of the driver to
the static Java class path for JDBC so your computer can establish a connection to the
database.
A Data Source Name (DSN) is the logical name that is used by Open Database
Connectivity (ODBC) to refer to the drive and other information that is required to access
data. This name is used to connect to an ODBC data source, such as a Microsoft SQL
Server database.
Find your database environment in the following table by choosing your platform
across the top and your database on the left. The link brings you to a page where you
can find information about installing the correct driver, defining a data source for
ODBC or adding the full path of your driver to the static Java class path for JDBC, and
establishing a database connection.
Database Platform
Windows Mac OS X 64-bit Linux 64-bit
Microsoft Access “Microsoft Access
ODBC for Windows”
on page 2-15
 
Microsoft SQL
Server
“Microsoft SQL
Server ODBC for
Windows” on page
2-23
“Microsoft SQL
Server JDBC for
Windows” on page
2-33
“Microsoft SQL
Server JDBC for
Mac OS X” on page
2-104
“Microsoft SQL
Server JDBC for
Linux” on page
2-111
Oracle “Oracle ODBC for
Windows” on page
2-44
“Oracle JDBC for
Windows” on page
2-48
“Oracle JDBC for
Mac OS X” on page
2-118
“Oracle JDBC for
Linux” on page
2-125