Provide an example of an ODBC ds file to be used with a JDBC-ODBC bridge connection
------------------------------------------------------------------------------------
Key: TEIID-1357
URL:
https://jira.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: Steven Hawkins
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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira