Difficulty in connecting to Access DB

shamo

<p>I have been trying for some days now connecting to Access DB and haven't been able to. Any help will be appreciated. Thanks in advance. Actuate 4.4</p>

micajblock

<p>The only way to do this is via JDBC ODBC bridge. There are many articles if you Google search - 'jdbc how to connect to access database'.</p>
<p> </p>
<p>That being said 2 comments:</p>
<ol><li>Access is NOT a multi-user databases so using this with iHub is highly discouraged.</li>
<li>Even Oracle (owner of Java) does not support the JDBC ODBC bridge in a production environment (<a data-ipb='nomediaparse' href='http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html'>http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html</a>) </li>
</ol><p> </p>
<p>Due to this below is an excerpt from our supported product matrix</p>
<ul><li>BIRT is expected to work with any JDBC 2.0 Type 2, 3 and 4 compliant database drivers. Note however that use of JDBC-ODBC bridge drivers is explicitly not recommended or supported</li>
</ul>