This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Solution (I think).

Posted by Miguel Mingo on December 11, 2001 at 1:01 PM

Hi. I had the same problem and there are a solution:
String url = "jdbc:odbc:MS Access Database;DBQ=C://";

For example:
String surl = "jdbc:odbc:MS Access Database;DBQ=C:/tmp/prueba2000.mdb";

Hope this help you.
>
> > > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > > > String myDB = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/data/month.MDB";
> > > > DBConn = DriverManager.getConnection(myDB,"","");

> Hi

> I try it out
> but it throw one exception

> like

> java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name too long.

> Please suggest me
> what to do

> Jaiwardhan