Sajan, be sure to have created your DSN as a system DSN. If you created your DSN as a User DSN this wont work. (I guess that you have created a DSN at all.) Grtx Jan -----Ursprüngliche Nachricht----- Von: sajan koshy george [mailto:[EMAIL PROTECTED]] Gesendet am: Montag, 30. Juli 2001 10:06 An: [EMAIL PROTECTED] Betreff: got a doubt Hi, when i installed tomcat as a service in nt machine.u get the default page and everything.but when i try to use a JSP page that has to interact with a database.i get the following error. Internal Servlet Error: javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:459) at jsp.apepmail._0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0._jsp Service(_0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0.java:137) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484) Root cause: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:199) at apepmail.sqlbean.makeConnection(sqlbean.java:19) at jsp.apepmail._0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0._jsp Service(_0002fjsp_0002fapepmail_0002fdetails_0002ejspdetails_jsp_0.java:87) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread This error comes only when i try to use tomcat as a service .if i directly start tomcat with startup.bat it works.is there any classpath or anything like that i should set for driver only?.would be grateful if u could help me out. with regards sajan _________________________________________________________ For Rs. 2,000,000 worth of Aptech scholarships click below http://events.rediff.com/aptechsch/scholarship.htm
