this work for me
<jdbc name="hotpoints">
<pool-controller min="5" max="10"/>
<dburl>jdbc:odbc:hotpoints-1.1</dburl>
</jdbc>
where just like you "hotpoints-1.1" is how i have register my .mdb in
odbci dont know .. but have you try to remove elements for username and
passwd?
--stavros
On Thu, 20 Jan 2005, yssr wrote:
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
