Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. DriverLoaded
  2. Could Not Connect to Databasejava.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
  3. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
  4. at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
  5. at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
  6. at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
  7. at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
  8. at java.sql.DriverManager.getConnection(Unknown Source)
  9. at java.sql.DriverManager.getConnection(Unknown Source)
  10. at DBConnect.<init>(DBConnect.java:11)
  11. at DBConnect.main(DBConnect.java:21)
  12.  
  13. import java.sql.*;
  14.  
  15. public class DBConnect {
  16.  
  17. public DBConnect() {
  18. try {
  19. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  20. System.out.println("DriverLoaded");
  21. String url = "jdbc:odbc:; DRIVER = Microsoft Access Driver (*.mdb, *.accdb); DBQ = DB.accdb";
  22. Connection con = DriverManager.getConnection(url);
  23. System.out.println("Connection Established Successfully");
  24. } catch(Exception e) {
  25. e.printStackTrace();
  26. System.out.println("Could Not Connect to Database");
  27. }
  28. }
  29.  
  30. public static void main (String args[]) {
  31. DBConnect dbcon = new DBConnect();
  32. }
  33. }
  34.  
  35. "jdbc:odbc:; DRIVER = Microsoft Access Driver (*.mdb, *.accdb); DBQ = DB.accdb"
  36.  
  37. File f = new File("\\***\***\****\***.accdb");
  38.  
  39. "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + f.getAbsolutePath();
  40.  
  41. import java.sql.*;
  42.  
  43. public class DBConnect {
  44.  
  45. public DBConnect() {
  46. try {
  47. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  48. System.out.println("DriverLoaded");
  49. String url = "jdbc:odbc:instance";
  50. Connection con = DriverManager.getConnection(url);
  51. System.out.println("Connection Established Successfully");
  52. } catch(Exception e) {
  53. e.printStackTrace();
  54. System.out.println("Could Not Connect to Database");
  55. }
  56. }
  57.  
  58. public static void main (String args[]) {
  59. DBConnect dbcon = new DBConnect();
  60. }
  61. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement