Hello all,
please help with jdbc problem :
it runs well on java, but problem in jsp..
here's the portion of my jsp program :
--begin--
<%@ page language="java" import="java.sql.*" %>
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println("just pass classforname..");
Connection myConn = DriverManager.getConnection("jdbc:odbc:mdbmahasiswa");
out.println("just pass getconnection");
// output resultset here...
}
catch(ClassNotFoundException cnfe) {
cnfe.printStackTrace();
}
catch(SQLException sqle) {
sqle.printStackTrace(new PrintWriter(out));
}
--end--
and here's the error log :
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:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
...
the funny thing is, when i try the same script in .java,
compile it, and run it, there's no problem at all..
what do i miss here ?
i'm using jrun 2.3.3, already included c:\jdk1.2.2\lib in jrun's
classpath
thanks in advance..
--
Best regards,
dion mailto:[EMAIL PROTECTED]
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
