Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1357

Provide an example of an ODBC ds file to be used with a JDBC-ODBC bridge connection

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 7.1.1, 7.3
    • 7.1
    • ODBC
    • None
    • Low

    Description

      Provide an example of an ODBC ds file for users to reference when connecting to a source through the JDBC-ODBC bridge. The ds file used in testing Excel is listed below:

      <?xml version="1.0" encoding="UTF-8"?>

      <datasources>
      <no-tx-datasource>
      <jndi-name>ExcelDS</jndi-name>

      <connection-url>jdbc:odbc:Driver=

      {Microsoft Excel Driver (*.xls)}

      ;Dbq=e:\ODBC_Testing\ODBC\EmpData.xls</connection-url>
      <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class>

      <transaction-isolation>TRANSACTION_NONE</transaction-isolation>
      <min-pool-size>1</min-pool-size>
      <max-pool-size>1</max-pool-size>
      <idle-timeout-minutes>5</idle-timeout-minutes>
      </no-tx-datasource>

      </datasources>

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            wgibson_jira Warren Gibson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: