How do I fill in the URL and Driver class fields in the 'Channel Edit Dialog', where the transport type is set to JDBC and the database is an ODBC compliant database ?

How do I fill in the URL and Driver class fields in the 'Channel Edit Dialog', where the transport type is set to JDBC and the database is an ODBC compliant database ?

book

Article ID: KB0087380

calendar_today

Updated On:

Products Versions
TIBCO IntegrationManager -
Not Applicable -

Description

Resolution:
URL : jdbc:odbc:xxx

where xxx is the ODBC DSN name.

Driver class : sun.jdbc.odbc.JdbcOdbcDriver

This class is in rt.jar, which comes as part of JRE installation. Make sure that it is in the CLASPATH

Issue/Introduction

How do I fill in the URL and Driver class fields in the 'Channel Edit Dialog', where the transport type is set to JDBC and the database is an ODBC compliant database ?

Environment

Product: TIBCO IntegrationManager Version: All OS: All --------------------