Connection String (Access database on server)

@kp2authorOct 24.2006 — #

[CODE]import java.sql.*;
 import java.io.*;
 import javax.servlet.*;
 import javax.servlet.http.*;
 
 public class ConnectAccess extends HttpServlet
 {
 public void doGet(HttpServletRequest request, 
 HttpServletResponse response)
 throws ServletException, IOException 
 {
 response.setContentType("text/html");
 PrintWriter out = response.getWriter();
 out.println("<html><head></head><title>Kevin's JDBC Access</title>" +"<BODY>n" +"<H2>Hello from the JDBC Access</H2>n");
 
   int i;
   Connection conn = null;
 
   // loading jdbc driver for access 
   try{
   //  System.out.println("Trying to load driver");
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
   } catch(Exception e) {
   System.out.println(e);
   }
 
   System.out.println("loaded driver");
 
   // connecting to database
   try{
   // connection string for database
   conn = DriverManager.getConnection
 ("jdbc:odbc://mudfoot.doc.stu.mmu.ac.uk:3306/porterk?user=******&password=*******/db1.mdb");
 System.out.println("Connection to database successful.");
 }
 catch(SQLException se) {
 System.out.println(se);
 }
 [/CODE]

Connection String (Access database on server)

2 Comments(s) _↴

Also in #Java _↴

Success!

Social

Version

Connection String (Access database on server)

2 Comments(s) ↴

Also in #Java ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #Java _↴