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

[Warren Gibson (JIRA)]

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