This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
Hi all: I am new to jsp and i met a problem while connecting to Microsoft Access. The following is the code: <%@ page import="java.sql.*" %> <html> <body> <% String name=request.getParameter("name"); String balance=null; if(name==null || "".equals(name)){ name=""; balance=""; } else{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); out.println("load driver"); Connection dbc=DriverManager.getConnection("jdbc dbc:kkk"); out.println("get connected"); Statement s=dbc.createStatement(); ResultSet rs=s.executeQuery("select balance from tt where name='"+name+"'"); if (rs.next()){ balance=rs.getString(1); } rs.close(); s.close(); dbc.close(); }catch(Exception ex){ out.println(ex.getMessage()); } }
The error message is: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified the datasoure "kkk" is in the ODBC pool and it tests well when I run a standalone program. Any ideas?