Created attachment 881187 [details] Image file showing tables not being listed while importing the DB(MS-ACCESS) using JDBC Description of problem: Unable to import metadata from MS-ACCESS in to the Teiid designer. Version-Release number of selected component (if applicable): -Tooling JBDS 7.x - Customer has tested this on MS-Access 2000, MS-Access 2010 and MS-Access 2013 - Windows 7 Professional on Desktop, - Windows Server 2008 R2 Standard on server. How reproducible: 1. Create a JDBC ODBC bridge connection profile (class: sun.jdbc.odbc.JdbcOdbcDriver) 2. Try importing using JDBC importer, no tables are shown Actual results: **************** Attaching No_ODBC_metadata.pdf (from client sent file) No tables listed. Expected results: ***************** While importing the database via JDBC, there should be a list of tables created in MS-ACCESS Additional info:
The work-around should be the suggested path for users connecting to MS Access since Teiid exposes applicable importer properties to properly import desired tables. Recommend we cover this in the doc, if we haven't already and close this issue as resolved?
Barry, given comment #2 - Documenting the workaround should in my opinion be sufficient.
Closing this since we are tracking issues for tooling only in JIRA from now on.
Barry LaFond <blafond> updated the status of jira TEIIDDES-2097 to Resolved
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2097 to Closed