Stupid reply...but do you have the properly jar file in the properly folder? Cheers Roberto
----- Original Message ----- From: "yssr" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, January 20, 2005 12:43 PM Subject: Re: MSAccess database problem > 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]
