About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
How does JDBC Adapter use ODBC data source to connect to a database?
Cause
Customer wants JDBC Adapter to use an existing ODBC data source to connect to the database server on Windows.
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.
[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF033","label":"Windows"}],"Version":"6.2.0.2;6.2.0.1;6.2;6.1;6.0.6;6.0.5;6.0.4;6.0.3;6.0.2.3;6.0.2.2;6.0.2.1;6.0.2;6.0.1;6.0.0.2;6.0.0.1;6.0","Edition":"","Line of Business":{"code":"","label":""}}]
Historical Number
PMR 28868004000
Product Synonym
Websphere JDBC adapter
JCA JDBC adapter
WBI JDBC adapter
Was this topic helpful?
Document Information
More support for:
WebSphere Adapters Family
Software version:
6.2.0.2, 6.2.0.1, 6.2, 6.1, 6.0.6, 6.0.5, 6.0.4, 6.0.3, 6.0.2.3, 6.0.2.2, 6.0.2.1, 6.0.2, 6.0.1, 6.0.0.2, 6.0.0.1, 6.0
Operating system(s):
Windows
Document number:
396657
Modified date:
15 June 2018
UID
swg21399636
Manage My Notification Subscriptions