One other note, if your web server is starting as an NT service, you must
make sure that the ODBC DSN you are trying to connect to is a System DSN,
not a user dsn.
(*Chris*)
----- Original Message -----
From: Luc Saint-Elie <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 12, 1999 12:26 AM
Subject: Re: Access, URGENT!!
>Le 01:53 12/03/99 +0200, Oguz Baktir a �crit:
>>Hi!!
>>Is there anyone who succefully retrieved info from Access 97 databases. If
>>so, can you tell me the step by step setting of the connection. How did
you
>>set the jdbc odbc connection?
>
>
>Oguz,
>
>The following code works.
>It DOES NOT mean that its a GOOD way to do this (I'm learning servlets) for
>example, perhaps its better to open the DB connection in the init() method.
>This code looks in an Access 97 database (DSN name : BIC) where are stored
>press releases and for the ten most recent ones gets the title and the date
and
>display them in a table.
>
>Hope this help
>
>import javax.servlet.*;
>import javax.servlet.http.*;
>import java.sql.*;
>import java.math.*;
>import java.io.*;
>import java.net.*;
>import java.util.*;
>
>
>public class Accueil extends HttpServlet
>{
> Connection con;
>
> public void init (ServletConfig config) throws ServletException
> {
> super.init(config);
> }
> //public void doPost(HttpServletRequest req, HttpServletResponse res)
> // throws ServletException, IOException
> public void service(HttpServletRequest req, HttpServletResponse res)
> throws ServletException, IOException
> {
>
> //register a driver
> try
> {
> DriverManager.registerDriver (new
>sun.jdbc.odbc.JdbcOdbcDriver());
> }
> catch(SQLException e)
> {
> log( "Probleme avec DriverMgr: " + e + '\t' );
> }
> //open a connection
> try
> {
> con = DriverManager.getConnection("jdbc:odbc:BIC", "","");
> }
> catch(SQLException e)
> {
> log( "Erreur Connexion: " + e + '\t' );
> }
> try
> {
>
> Statement stmt = con.createStatement();
> int columns = 0;//how many columns are returned in the ResultSet
>
> String sql = "SELECT * FROM Articles_News ORDER BY DateSaisie DESC
;";
> stmt.execute(sql);
> ResultSet rs1 = stmt.getResultSet();
> ResultSetMetaData rsmd = rs1.getMetaData();
> columns = rsmd.getColumnCount();
>
> res.setContentType("text/html");
> res.setDateHeader( "Expires", new java.util.Date().getTime() );
> PrintWriter out = res.getWriter();
> out.println(
> "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0//EN//\">"+
> "<html>"+
> "<head>"+
> "<meta HTTP-EQUIV=\"expires\" content=\"0\">"+
>
> [... LOT OF HTML HERE....]
> );
>
> if(columns > 0)
> {
>
> out.println(
>
> [...LOT OF HTML HERE ...]
>
> );
> stmt.execute(sql);
> ResultSet rs = stmt.getResultSet();
> for(int i = 0; i<10; i++){
> if(rs.next())
> {
> //get the info here
> String strTitre = rs.getString("Titre");
> String strDateSaisie = rs.getString("DateSaisie");
> out.println(
>
> [...LOT OF HTML HERE: The data extracted from the database...]
> );
> }
> }
> out.println(
> [...LOT OF HTML HERE...]
> );
> }
> else
> {
> out.println(
> [...LOT OF HTML HERE...]
> );
> }
>
> out.println(
> [... LOT OF HTML HERE...]
> );
> out.flush();
> stmt.close();
> con.close();
>
> }
> catch(SQLException e)
> {
> //out.println
> log( "Erreur SQL: " + e + '\t' );
> }
> }
>}
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
