Results 1 to 1 of 1
- 11-24-2008, 04:34 PM #1
Member
- Join Date
- Nov 2008
- Location
- Kuala Lumpur,Malaysia
- Posts
- 16
- Rep Power
- 0
connection between ms access and jcreator
Dear viewers,
when i compile with jcreator (SimpleDeleteSelect.java)it says process completed,and when i run there are error message ...my database(ms access) cannot perform deletion but all my friends with laptop don't face any problem and desktop in my college also face the same problem with mine at home......what is the problem ???
My connection path between jcreator with ms access is
Control Panel-->Administrative Tool-->Data Sources--> MS Access Database--> add-->ms access driver(.mdb)-->data source name=TARCollegeDB-->create-->then i the path where i save my file(Ms access)-->then press OK three times
(Please verify my path)
================================================== ======
//error message
Driver loaded...
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.j ava:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOd bcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDrive r.java:174)
at java.sql.DriverManager.getConnection(DriverManager .java:582)
at java.sql.DriverManager.getConnection(DriverManager .java:207)
at SimpleInsertSelect.main(SimpleInsertSelect.java:12 )
Process completed
================================================== =====
//the coding of SimpleDeleteSelect.java
import java.sql.*;
public class SimpleDeleteSelect {
public static void main(String[] args) throws SQLException, ClassNotFoundException{
// load the JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Driver loaded...\n");
// establish a connection
Connection conTARCollegeDB = DriverManager.getConnection("jdbc:odbc:TARCollegeD S");
System.out.println("College database connnected...\n");
// create a statement
Statement stmtDelete = conTARCollegeDB.createStatement();
// execute a statement
stmtDelete.executeUpdate("DELETE FROM Course WHERE CourseID = 'CCS';");
// create a statement
Statement stmtSelect = conTARCollegeDB.createStatement();
// execute a statement
ResultSet rsStudent = stmtSelect.executeQuery("SELECT * FROM Course;");
// loop through the ResultSet and print out student details
while(rsStudent.next()){
System.out.println("Course ID: " + rsStudent.getString(1)+ "\t\tCourse Description: " + rsStudent.getString(2));
}
} // end main
} // end class
Similar Threads
-
Accessing MS Access using DSN less connection
By Java Tip in forum Java TipReplies: 1Last Post: 03-31-2009, 06:25 PM -
JCreator JDK docs?
By thejerryman in forum JCreatorReplies: 4Last Post: 12-01-2008, 05:31 PM -
About using jcreator
By yuchuang in forum JCreatorReplies: 4Last Post: 11-29-2008, 09:29 PM -
jcreator
By nikhil_solanki015 in forum JCreatorReplies: 2Last Post: 10-28-2008, 08:04 PM -
using Java to access a secure webpage, Exception occurred: Connection timed out
By toby in forum Enterprise JavaBeans (EJB)Replies: 1Last Post: 08-07-2007, 07:03 AM
Bookmarks