Hi
the below also I tried but it is saying that
"Datasource not found"(in log)
1. my web.xml entry in load classes
<!-- For ODBC -->
sun.jdbc.odbc.JdbcOdbcDriver
2.my cocoon.xconf entry
<jdbc name="JDBCODBCdb">
<pool-controller min="2" max="20"/>
<auto-commit>false</auto-commit>
<dburl>jdbc:odbc:SSPer</dburl>
<user></user>
<password></password>
</jdbc>
SSPer is datasource name I gave in ODBC(control panel
etc....)
3.in XSP
<?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>JDBCODBCdb</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>
But still a problem...
any sugession.
===========
Thanks
yssr
--- [EMAIL PROTECTED] wrote:
>
> 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]
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
