MDB
i am creating one mdb file . how to access the mdb file without dsn name.
this is my mdb file creation coding
import java.sql.DriverManager;
import java.io.*;
import sun.jdbc.odbc.ee.DataSource;
class Access
{
java.sql.Connection con;
java.sql.PreparedStatement pstmt;
java.sql.ResultSet rst;
java.sql.Statement st;
public Access()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.io.File j1 = java.io.File.createTempFile("Test",".mdb",new File("c:\\"));
//con=DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver(*.dbf)};DBQ=c:"+File.pathSeparator+"Data.mdb");
System.out.println( "Connection successfully");
// st = con.createStatement ();
// DataSource db = Database.create(new File("new.mdb"));
//pstmt=con.prepareStatement("Select * from tablename");
//rst=pstmt.executeQuery();
//if(rst.next())
//{
// System.out.println(rst.getNString(1));
// }
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String[]args)
{
Access a=new Access();
}
}
plz give me the proper solution
by
devi
