Hi everyone, I am trying to connect to an Access database while running Tomcat 5.0.28. I have the ODBC node defined under the System DSN and when I start Tomcat manually, everything works fine. However, when I start Tomcat from the service, everything works fine, except for the page connecting to the database. I get the following error:
2005-06-14 23:13:06 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception com.borland.dx.dataset.DataSetException: General error at com.borland.dx.dataset.DataSetException.a(Unknown Source) at com.borland.dx.dataset.DataSetException.throwException(Unknown Source) at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source) at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source) at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown Source) at com.borland.dx.sql.dataset.o.a(Unknown Source) at com.borland.dx.sql.dataset.o.d(Unknown Source) at com.borland.dx.sql.dataset.o.f(Unknown Source) at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source) at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source) at com.borland.dx.dataset.StorageDataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.a(Unknown Source) at com.borland.dx.dataset.DataSet.open(Unknown Source) at com.cri.common.dataAccess.DataSourceBase.setBound(DataSourceBase.java:281) at com.cri.common.dataAccess.DataSourceNode.getDataSource(DataSourceNode.java:139) at com.cri.common.dataAccess.DataAccessManager.isDataSourceAvailable(DataAccessManager.java:485) at com.cri.utility.EConExplorer.dataSourceAvailabilityForContentObject(EConExplorer.java:2805) at com.cri.utility.EConExplorer.displayContentObject(EConExplorer.java:2829) at com.cri.utility.EConExplorer.processViewLocalContentObject(EConExplorer.java:1331) at com.cri.utility.EConExplorer.initializeComponent(EConExplorer.java:2527) at com.cri.utility.EConExplorer.process(EConExplorer.java:364) at org.apache.jsp.jsp.usr.LeftPane_jsp._jspService(LeftPane_jsp.java:55) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:536) Can anyone point me in the right direction to solve this? Thanks! John Lindley __________________________________ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]