in windows platform you can create an ODBC entry for your .mdb file
and use the connection string:
jdbc:odbc:{your_dsn_entry}
that work for me
--stavros
On Thu, 20 Jan 2005, yssr wrote:
> Hi All,
>
> How can i retrieve a MSAccess databases.
> now I am using "Atinav Access Component" but I it is
> not working properly
>
> 1.I placed the jar in the lib
> 2.Added entry in load-class(web.xml)
> 3.database pool (cocoon.xconf)
> <jdbc name="MSdb">
> <pool-controller min="2" max="20"/>
> <auto-commit>false</auto-commit>
>
> <dburl>jdbc:atinav:localhost:7227:d:\\testdatabase\db1.mdb</dburl>
> <user></user>
> <password></password>
> </jdbc>
> 4.stated 3rd party service
>
> Problem is nothing comming , when I place it in
> simple xsp i.e,
> <?xml version="1.0"?>
> <xsp:page language="java"
> xmlns:esql="http://apache.org/cocoon/SQL/v2";
> xmlns:xsp="http://apache.org/xsp";>
> <emp>
> <esql:connection>
> <esql:pool>MSdb</esql:pool>
> <esql:execute-query>
> <esql:query>SELECT id,name,place FROM
> emp</esql:query>
> <esql:results>
> <table>
> <esql:row-results>
> <tr>
> <td><esql:get-string column="id"/></td>
> <td><esql:get-string column="name"/></td>
> <td><esql:get-string column="place"/></td>
> </tr>
> </esql:row-results>
> </table>
> </esql:results>
> <esql:no-results>
> <p>Sorry, no results!</p>
> </esql:no-results>
> </esql:execute-query>
> </esql:connection>
> <h1>Test</h1>
> </emp>
> </xsp:page>
>
> when I use serialize type as html
> nothing is comming.
> when I use serialize type as xml
> it is showing error (root tag is mandatory)[i can
> guess i.e, because there is no data in response]
>
> Any sugession will help a lot....
>
> Is there any other way to access "MSAccess"
>
> Thanks
> yssr
>
>
>
> __________________________________
> Do you Yahoo!?
> Take Yahoo! Mail with you! Get it on your mobile phone.
> http://mobile.yahoo.com/maildemo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
