java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]

Discussion in 'Java Forums' started by bghafhsnhkk, Apr 9, 2013.

  1. bghafhsnhkk

    bghafhsnhkk New Member

    I am using this program for connecting with the Ms Access 2007 and getting Exception please help me out.The Exception is, I have checked many tutorials but not getting the best solution.\[quote\] java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.\[/quote\]\[code\]at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956)at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113)at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3072)at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323)at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)at java.sql.DriverManager.getConnection(DriverManager.java:579)at java.sql.DriverManager.getConnection(DriverManager.java:221)at multithreading.dbAccess.main(dbAccess.java:14)import java.sql.*;public class dbAccess{public static void main(String[] args){ try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String database = "jdbc:eek:dbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=payroll.mdb;"; Connection conn = DriverManager.getConnection(database, "", ""); Statement s = conn.createStatement(); // create a table String tableName = "myTable" + String.valueOf((int)(Math.random() * 1000.0)); String createTable = "CREATE TABLE " + tableName + " (id Integer, name Text(32))"; s.execute(createTable); // enter value into table for(int i=0; i<25; i++) { String addRow = "INSERT INTO " + tableName + " VALUES ( " + String.valueOf((int) (Math.random() * 32767)) + ", 'Text Value " + String.valueOf(Math.random()) + "')"; s.execute(addRow); } // Fetch table String selTable = "SELECT * FROM " + tableName; s.execute(selTable); ResultSet rs = s.getResultSet(); while((rs!=null) && (rs.next())) { System.out.println(rs.getString(1) + " : " + rs.getString(2)); } // drop the table String dropTable = "DROP TABLE " + tableName; s.execute(dropTable); // close and cleanup s.close(); conn.close(); } catch(Exception ex) { ex.printStackTrace(); }}}`\[/code\]
     

Share This Page