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
i think you should use the "sun.jdbc.odbc.JdbcOdbcDriver"
rather than "sun.jdbc.odbc.JdbcOdbc"
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.
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.