http://www.paphoscarhire.mobi/odbc-bridge2.jpg


desktop control panel settings, I have above URL (IMG) Settings
well, I need to run in my PC: Type 1 db driver Access / java[SE1.6] Desktop Applications, what I need to install ?


I refer for Type 1, JDBC-ODBC Bridge driver.... Is it needed install and Access 2003 ODBC driver (see URL) ...? How I understand if I already installed it(?) since I do not know ?

How to load driver in my program ? The below are correct for: Class.forName & DriverManager.getConnection ?
Code:
 class  ResultSetDemo    {
  public static void main (String  [ ] args)    {
    try {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       Connection conn
          =DriverManager.getConnection("jdbc:odbc:RedWines");  // DSN=RedWines
       Statement  sttmnt  =  conn.createStatement (  );

I GET ERROR !
Code:
C:\Users\User\Documents\TextBooks Data Files\The Web Warrior Guide to Web Database Technolo
gies, 1st Edition\extract\Chapter06\Chapter>java ResultSetDemo
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM claus
e.
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
        at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
        at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
        at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
        at ResultSetDemo.main(ResultSetDemo.java:10)

 
C:\Users\User\Documents\TextBooks Data Files\The Web Warrior Guide to Web Database Technolo
gies, 1st Edition\extract\Chapter06\Chapter>