connecting to MS-Access 97 database

Iam working on Windows 95 and trying to connect to

MS-Access 97 database using the following code:

String url = "jdbc:odbc:MS Access 97

Database;DBQ=c:\\utuGatewayCtl\\HEM0000101.MDB";

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection(url);

and Iam getting the following error mesage:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is

not a valid path. Make sure that the path name is spelled correctly and that yo

u are connected to the server on which the file resides.

Can anyone help me?

[647 byte] By [akkiraju_lk] at [2007-9-26 1:52:40]
# 1
I would guess its the URLString url = "jdbc:odbc:MS Access 97I think it has to be the name of the ODBC connection (in your odbc-setup)and it also might be the fact that this line is missing a "hope it helps,-r
ReynirH at 2007-6-29 3:02:45 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...