Wednesday, April 22, 2009

sql server and access type 4 connection code

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection("jdbc:sqlserver://121.241.213.156:1433;databasename=test;user=test;password=test;");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\\\c71\\\\My Sql\\\\1\\\\att.mdb");

No comments:

Post a Comment