MS Access with JAVA

Discussions

EJB programming & troubleshooting: MS Access with JAVA

  1. MS Access with JAVA (3 messages)

    I would like to retrieve daten within the MS Access database
    but I do not know which configuration I have to do. Then in my java class i use this ( String JDBCDRIVER ="sun.jdbc.odbc.JdbcOdbc";) and this (String URL ="jdbc:odbc:productionworld.mdb";) but i receive anytime the error " No suitable driver " . I use Win 2000 and eclipse as
    IDE.

    thanks.

    Threaded Messages (3)

  2. MS Access with JAVA[ Go to top ]

    i think you should use the "sun.jdbc.odbc.JdbcOdbcDriver"
    rather than "sun.jdbc.odbc.JdbcOdbc"
  3. MS Access with JAVA[ Go to top ]

    I don't know the specifics of access but usually in windows you have to register the actual database with the ODBC data sources and then connect to it through the name you give it in ODBC sources.
    Michael
  4. MS Access with JAVA[ Go to top ]

    The Driver should be 'sun.jdbc.odbc.JdbcOdbcDriver'.
    And the url should be 'jdbc:odbc:DSNNAME'.
    The DSNNAME is the DataSource Name which is pointing to the mdb file.