Error in Automatic Creation of ODBC Data Source

[gayathri murugesan]

String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + System.getProperty ("user.dir") System.getProperty ("file.separator") + "icudb.mdb";
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection icuCon = DriverManager.getConnection (url);
}catch(Exception e)
{
   e.printStackTrace();
}

i m getting ';' expected

please help

[Campbell Ritchie]

Which line is it on? Is it the line with the + missing before System.getProperty?

[gayathri murugesan]

thanks .i corrected that one. but now when i run i m getting

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find
file '(unknown)'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:11)

the code

 
import java.sql.*;

public class Test
{
  public static void main(String[] args)
  {
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + System.getProperty ("user.dir") + System.getProperty ("file.separator") + "icudb.mdb";
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection icuCon = DriverManager.getConnection (url);
}catch(Exception e)
{
   e.printStackTrace();
}
}
}