How to enable Microsoft Access Driver (*.mdb, *.accdb) in Microsoft Azure server?

Need help with the webapplication program?

• i need to connect microsoft access 2007 with netbean j2ee program. my code is Connection con; Statement st; try{ Class.forName("sun6.jdbc.odbc.JdbcOdbcDr… con=DriverManager.getConnection("jdbc:od… st=con.createStatement(); st.executeUpdate("insert into logintabl values('"+a+"','"+b+"','"+c+"',"+d+")"); con.close(); i selected Administrative tool->data source->system dsn->Microsoft Access Driver(*.mdb, *.accdb) and gave the name has dsn999. created one database in microsoft access and gave all the attributes.but it's not connecting... is there any step that i am skipping. pls help. i will be grateful..<3

• Answer:

  1)Class.forName("sun6.jdbc.odbc.JdbcOdbc… check whether it is sun6.jdbc.odbc.... or sun.jdbc.odbc........ 2) st.executeUpdate("insert into logintabl values('"+a+"','"+b+"','"+c+"',"+d+")"); you have not insert ' ' in case of d.That should be ' " +d+ " '