How can I remotely connect to ODBC using Java in Windows XP?

Question

My remote database is a Mysql database, and I want to get some records and put them in the Microsoft Access database, which is the localhost database

and I want to also create a DSN for the remote database

Please help me

Answer 1

I have a similar setup working in MATLAB that uses java to connect to MySQL and Access databases. I created a java class with the following method

/** * Open a connection to a MySQL database * @param userName registered user on the MySQL database. * @param userPassword MySQL database password for the named user. * @param databaseUrl database name eg. 'jdbc:mysql://glnd2818898.network.net/matlab' */ public void openMySQLConnection(String userName, String userPassword, String databaseUrl){ try { Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (databaseUrl, userName, userPassword); }catch (SQLException e) {System.err.println ("Cannot connect to database server");} } 

This is done over the internal network since the comments defining databaseUrl glnd2818898.network.net are the MySQL server and it connects to the matlab database

The access interface is similar to

  private static final String accessDBURLPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; private static final String accessDBURLSuffix = ";READONLY=true}"; /** * Open a connection to a Access database * @param userName registered user on the Access database. * @param userPassword Access database password for the named user. * @param databaseUrl database name eg. 'pathname/accessName.mdb' */ public void openConnAccess(String userName, String userPassword, String databaseUrl){ try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dbUrl = accessDBURLPrefix + databaseUrl + accessDBURLSuffix; conn = DriverManager.getConnection (dbUrl, userName, userPassword); }catch (SQLException e) {System.err.println ("Cannot connect to database server :" + e.getMessage());} } 

This is probably not the clearest java encoding since it was my first attempt from the point of view of MATLAB users, but it works for me.

Answer 2

You want to use JDBC ODBC Bridge to connect to the ODBC database.