No you do not, they come for free with the jdk. But as I told you I would not reccomend them for large systems...
15/01/2002 12:41:23, "Wilson E. Lozano R." <[EMAIL PROTECTED]> wrote: >ok Panos.. thanks, but, then i don't need to download any jdbc:odbc drver? >?? >Thanks in advanced. >----------------------------------- >Wilson Ernesto Lozano RolOn >Ingeniero de Sistemas >----------------------------------- > >On Tue, 15 Jan 2002, panos periorellis wrote: > >> OK fellas for once and for all.... >> >> if you have a an access database and you want to connect it with JAVA or JSP >> you do the following >> >> go to control panel and open ODBC data source....click on tab user DSN >> click on MS access and click on Add >> Select MS access again Click Finish...i will aks for a datasource name >> Give it a name...such as 'phonedirectory' and then Click on Select button >> and select your msaccess database in your directory example phonebook.mdb >> >> NOW you have a data source connected to your access database ... >> >> NOw in your JSP or JAVA program write the follogin code.. >> >> try { >> Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); >> Connection con = >> DriverManager.getConnection("jdbc:odbc:phonedirectory"); >> >> String sql = "SELECT * FROM phonenumbers;"; // this is an example of a >> table inside the phonebook ms access database >> System.out.println( "set the SQL"); >> >> Statement stmt= con.createStatement(); >> System.out.println( "SET THE STATEMENT "); >> >> ResultSet rs=stmt.executeQuery(sql); >> >> System.out.println( "Executing SELECT query "); >> while (rs.next()) { >> >> String s = rs.getString("name"); >> >> String n = rs.getString("number"); >> >> } >> con.close( ); >> >> } catch( Exception e ) { >> System.out.println(e); >> System.exit( -1 ); >> } >> >> >> HOPE this helps >> panos >> >> =========================================================================== >> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". >> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". >> Some relevant FAQs on JSP/Servlets can be found at: >> >> http://archives.java.sun.com/jsp-interest.html >> http://java.sun.com/products/jsp/faq.html >> http://www.esperanto.org.nz/jsp/jspfaq.jsp >> http://www.jguru.com/faq/index.jsp >> http://www.jspinsider.com >> > >=========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > __________________________________________ "It can only be attributed to human error" 2001 A Space Odyssey =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com