[teiid-issues] [JBoss JIRA] Closed: (TEIID-1357) Provide an example of an ODBC ds file to be used with a JDBC-ODBC bridge connection

Provide an example of an ODBC ds file to be used with a JDBC-ODBC bridge connection ------------------------------------------------------------------------------------ Key: TEIID-1357 URL: https://issues.jboss.org/browse/TEIID-1357 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.1 Environment: Teiid using JDBC-ODBC bridge connection to a vdb source Reporter: Warren Gibson Assignee: Ramesh Reddy Priority: Minor Fix For: 7.1.1, 7.3 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>