Is it possible to configure a MS Access database as a resource?
Is there a way to trick the resource 揇atabase Table?to accept connections to MS Access?
I抳e seen that one can specify de JDBC Driver en URL, so may be using one of JDBC-ODBC bridges available it抯 possible to connect!!
Can anyone help me in this issue?
Yes, you can use MS Access as database for a 'Database Table' resource. You will need to first do the ODBC configuration. Then when creating a new resource, specify sun.jdbc.odbc.JdbcOdbcDriver as the driver and the URL should be jdbc:odbc:<odbc name>.
However, you will not be able to use the wizard to do the configuration. You will have to manually edit the XML file and then import it.
What do you mean by create a resource? In configure tab > manage resources? Or new Resource wizard and then at database table specify the driver and URL?
Afterwards where is the XML located so I can modify it?
I抦 also trying to do the connection using Easysoft JDBC-ODBC Bridge, I have copy de jar with the classes to \common\lib and then at the Database table wizard I specify the driver and URL, but it doesn抰 work!!
Do you have any idea how can I achieved this? Is it possible?
Thanks again for your help!!
You cannot use the wizard.
What i did to connect to MS Access.... was to use the wizard to create a resource for a MySQL table to get a sample XML file. I then edited the resource XML and changed the values for driver, database name, table name, schema etc to correspond to the ODBC connection. You can edit the resource XML from the debug pages.
