I guess you forget to create your ODBC datasource regards, iws -----Original Message----- From: dion [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 09, 2000 10:08 PM To: [EMAIL PROTECTED] Subject: JdbcOdbcDriver runs well in java but problem in jsp... 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 =========================================================================== 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
