Thread: MS-Access database

Help me out in connecting to the MS-Access database using Struts and using Weblogic server?

Note : This is the question asked by a visitor viswanath. I am posting this in proper forum.

Hi,
In your file struts-config.xml the data connection for MS Access should be given as,

<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName" value="sun.jdbc.odbc.JdbcOdbcDriver" />
<set-property property="url" value="jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ='d:/srik/db1.mdb';DriverID=22;}" />
</data-source>

*** Mangai Varma ***