Access -> mysql

[Martin Schneider]

Hi there,
I want to switch from access to mysql but I don't know how to do it :| I'd be really grateful if someone could explain me step by step how to perform this task. Right now Im using "dnsless-connection" and that is the way it should be with mysql.

  static String dir = System.getProperty( "user.dir" );
  static String conString="jdbc : odbc : DRIVER={Microsoft Access Driver (*.mdb)};SERVER=myserver;DBQ="+dir+"\\myDb.mdb";
//method creating Connection
  public static Connection connect()
  {
    Connection con = null;
    try
    {
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
      con = DriverManager.getConnection(conString);
    }// try
    catch( Exception ex )
    {
      System.out.println(ex);//ex.printStackTrace
    }
    return con;
  }  

[ August 01, 2002: Message edited by: Martin Schneider ]

[Juanjo Bazan]

The java code you should change is really short. Once you have download the JDBC package ( available from http://www.mysql.com/downloads/contrib.html )and put it in your classpath, just change the driver you are loading:
Class.forName("org.gjt.mm.mysql.Driver");
And of course set the apropiate connection url/port/user/pass.
About the features of MySQL you should check www.mysql.com, because maybe there are not implemented some options (ResultSet features,...)
-HTH