Connecting to MS Access[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Solution Verified - Updated -

Issue

We have a new requirement to connect to MS Access databases. I am trying to follow the instructions on the link
https://access.redhat.com/solutions/1380883 but I am getting the following error when I try starting my local server:

2016-01-15 11:32:23,719 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 1) IJ000604: Throwable while attempt
ing to get a new connection: null: javax.resource.ResourceException: Could not create connection
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:356)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:304)
.. .. .. .. 
        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:286)
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:57)
        at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:194) [teiid-api-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
        at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:58) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1
.6_2-redhat-6]
        at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.1.6_2-redhat-6.jar:8
.7.1.6_2-redhat-6]
        at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
        at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
.. .. .. .. 
Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956) [rt.jar:1.7.0_17]
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113) [rt.jar:1.7.0_17]
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3072) [rt.jar:1.7.0_17]
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323) [rt.jar:1.7.0_17]
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) [rt.jar:1.7.0_17]
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:328)
        ... 20 more

2016-01-15 11:32:23,744 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB AccessVDB.1 model "AccessModel" metadata failed to load. Re
ason:TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/AccessData

Environment

  • Red Hat JBoss Data Virtualization 6.2.0
    • Connect to MS Access Datasource

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.