Connecting to a database server on Windows using existing ODBC Data Source for WebSphere Adapter for JDBC

Resolving The Problem

1. Configure an ODBC data source using the ODBC Data Source Administrator.
a.) Click Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC),
b.) Click the System DSN tab.
c.) Click Add to create a new data source and configure the connection information. Specify the DataSource Name, User and Password for the database. Test the connection to ensure that you are able to successfully connect to the database.

2. Configure the connection information:
§ For JCA adapter for JDBC, in the Discovery Configuration window of the external service window, specify the following configuration to connect to the database server:
JDBC driver class name: sun.jdbc.odbc.JdbcOdbcDriver
Database URL: jdbc:odbc:odbcsrName





Note:
1)"sun.jdbc.odbc.JdbcOdbcDriver" is the driver class name of the JDBC-ODBC Bridge driver. The driver class is included in the JRE in the path \jre\lib\core.jar

2) "odbcsrcName" of the name of the ODBC datasource.


§ For WBI JDBC Adapter, configure the connection information in the Application specific information panel.