Database problem

hai i'm using apache tomcat 5.0 for jsp and oracle 9i as back end. when i execute the program in IE it shows the following error. how to solve it. thanks in advance.

HTTP Status 500 -

--

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)

org.apache.jsp.UserName_005fConfirmation_jsp._jspService(UserName_005fConfirmation_jsp.java:1464)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)

sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)

sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)

sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)

sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)

java.sql.DriverManager.getConnection(DriverManager.java:525)

java.sql.DriverManager.getConnection(DriverManager.java:171)

org.apache.jsp.UserName_005fConfirmation_jsp._jspService(UserName_005fConfirmation_jsp.java:1170)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

--

Apache Tomcat/5.0.28

[2543 byte] By [lintaa] at [2007-11-26 14:54:49]
# 1
use the jdbc driver of oracle not the type 1 driver.. do not use DNS
jgalacambraa at 2007-7-8 8:43:17 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
i try
lintaa at 2007-7-8 8:43:17 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 3
hai in my driver list only odbc for oracle and oracle in ora home 90 only available. what should i do?
lintaa at 2007-7-8 8:43:17 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 4
download the jdbc driver for oracle ojdb14.jar and use it
jgalacambraa at 2007-7-8 8:43:17 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...