Hi all,

i downloaded mondrian.war and placed it in tomcat/webapps.
i am using mysql client to connect to mysql server runninf in another system.
and tomcat 5 as web server.
i followed the steps given in a doc called how to install mondrian...
jdbc Driverm using is mysql-connector-java-3.0.11-stable...

when i execute a MDX query ,the following error is thrown..

where am i going wrong.....??


org.apache.commons.dbcp.DbcpException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnection(DriverManagerConnectionFacto ry.java:101)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.bor rowObject(Unknown Source)
at org.apache.commons.dbcp.PoolingDataSource.getConne ction(PoolingDataSource.java:110)
at mondrian.rolap.SqlMemberSource.getLevelMemberCount (SqlMemberSource.java:97)
at mondrian.rolap.SqlMemberSource.getMemberCount(SqlM emberSource.java:81)
at mondrian.rolap.RolapSchema.createMemberReader(Rola pSchema.java:399)
at mondrian.rolap.RolapSchema.createMemberReader(Rola pSchema.java:338)
at mondrian.rolap.RolapHierarchy.init(RolapHierarchy. java:131)
at mondrian.rolap.RolapDimension.init(RolapDimension. java:119)
at mondrian.rolap.RolapCube.init(RolapCube.java:174)
at mondrian.rolap.RolapCube.<init>(RolapCube.java:76)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:1 15)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :93)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java :34)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.ja va:249)
at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:89)
at mondrian.rolap.RolapConnection.<init>(RolapConnect ion.java:60)
at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:133)
at mondrian.olap.DriverManager.getConnection(DriverMa nager.java:49)
at mondrian.web.servlet.MDXQueryServlet.processReques t(MDXQueryServlet.java:84)
at mondrian.web.servlet.MDXQueryServlet.doGet(MDXQuer yServlet.java:213)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:257)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardContextValve.invo keInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:195)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(Co yoteAdapter.java:206)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnection(DriverManagerConnectionFacto ry.java:98)
... 47 more
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified