Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DriverLoaded
- Could Not Connect to Databasejava.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
- at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
- at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
- at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
- at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at DBConnect.<init>(DBConnect.java:11)
- at DBConnect.main(DBConnect.java:21)
- import java.sql.*;
- public class DBConnect {
- public DBConnect() {
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- System.out.println("DriverLoaded");
- String url = "jdbc:odbc:; DRIVER = Microsoft Access Driver (*.mdb, *.accdb); DBQ = DB.accdb";
- Connection con = DriverManager.getConnection(url);
- System.out.println("Connection Established Successfully");
- } catch(Exception e) {
- e.printStackTrace();
- System.out.println("Could Not Connect to Database");
- }
- }
- public static void main (String args[]) {
- DBConnect dbcon = new DBConnect();
- }
- }
- "jdbc:odbc:; DRIVER = Microsoft Access Driver (*.mdb, *.accdb); DBQ = DB.accdb"
- File f = new File("\\***\***\****\***.accdb");
- "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + f.getAbsolutePath();
- import java.sql.*;
- public class DBConnect {
- public DBConnect() {
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- System.out.println("DriverLoaded");
- String url = "jdbc:odbc:instance";
- Connection con = DriverManager.getConnection(url);
- System.out.println("Connection Established Successfully");
- } catch(Exception e) {
- e.printStackTrace();
- System.out.println("Could Not Connect to Database");
- }
- }
- public static void main (String args[]) {
- DBConnect dbcon = new DBConnect();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement