DaniWeb Forum Index > Web Development > JSP

DataBase connection in Jsp to MS-Access

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 9

Reputation: nireekshan is an unknown quantity at this point

Solved Threads: 0

nireekshan nireekshan is offline

Offline

Newbie Poster

DataBase connection in Jsp to MS-Access

Mar 25th, 2008

hello
i am nireekshan i have some prouble in database connection
send my erres pless see and send Some Code .
//...............................//

 Help with Code Tags 
 java Syntax (Toggle Plain Text) 
import java.sql.*;
class Student
{
public static void main(String args[]) throws Exception
{
try
{
 
import java.sql.*;
class Student
{
public static void main(String args[]) throws Exception
{
try
{
String database="c:\\student.mdb";
String url="jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false";
 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:student");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select *from studtable");
while(rs.next())
{
	int no=rs.getInt(1);
	String name=rs.getString(2);
	String address=rs.getString(3);
	System.out.println(no+" "+name+" "+address);
}
System.out.println("connected");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
***************************************************************************************************************//in the above program was working Good  ,not any arrer But Bellow Program was some arrer
##########################################################################
//
String database="c:\\student.mdb";
String url="jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false";
 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select *from studtable");
while(rs.next())
{
	int no=rs.getInt(1);
	String name=rs.getString(2);
	String address=rs.getString(3);
	System.out.println(no+" "+name+" "+address);
}
System.out.println("connected");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
import java.sql.*;
class Student
{
public static void main(String args[]) throws Exception
{
try
{

import java.sql.*;
class Student
{
public static void main(String args[]) throws Exception
{
try
{
String database="c:\\student.mdb";
String url="jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false";

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:student");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select *from studtable");
while(rs.next())
{
	int no=rs.getInt(1);
	String name=rs.getString(2);
	String address=rs.getString(3);
	System.out.println(no+" "+name+" "+address);
}
System.out.println("connected");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
***************************************************************************************************************//in the above program was working Good  ,not any arrer But Bellow Program was some arrer
##########################################################################
//
String database="c:\\student.mdb";
String url="jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=false";

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select *from studtable");
while(rs.next())
{
	int no=rs.getInt(1);
	String name=rs.getString(2);
	String address=rs.getString(3);
	System.out.println(no+" "+name+" "+address);
}
System.out.println("connected");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}

Exception in thread "main" java.sql.SQLException:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Last edited by peter_budo; Mar 26th, 2008 at 5:18 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Mar 2008

Posts: 2

Reputation: p4u9999 is an unknown quantity at this point

Solved Threads: 0

p4u9999

Offline

Newbie Poster

Re: DataBase connection in Jsp to MS-Access

Mar 25th, 2008

Try this code ....
I have change table name and database name....so plz update is accodingly

your problem was in red line...check it

Help with Code Tags

(Toggle Plain Text)

import java.sql.*;
class student
{
public static void main(String args[]) throws Exception
   {
	try
	{
		String database="c:\\student.mdb";
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + database + ";DriverID=22;READONLY=true"; 
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection(url,"","");
		Statement stmt=con.createStatement();
		ResultSet rs=stmt.executeQuery("select *from studenttable");
		while(rs.next())
			{
				int no=rs.getInt(1);
				String name=rs.getString(2);
				String address=rs.getString(3);
				System.out.println(no+" "+name+" "+address);
			}
			System.out.println("connected");				
		}
		catch(Exception e)
		{
				e.printStackTrace();
		}
	}
}

Last edited by peter_budo; Mar 26th, 2008 at 5:21 pm. Reason: Keep It Organized - please use [code] tags