Wednesday, October 24, 2012

[android-developers] Error while Connecting to MS Access Database From Android


I'm trying to retrieve data's from MS Access Database on my desktop. I didn't add any external jar file to retrieve data actually i don't know whether i have to export any external jar file for accomplishing this. Here is the code which i'm using to connect to Ms Access Database on my PC.

String driver = "sun.jdbc.odbc.JdbcOdbcDriver";              Class.forName(driver).newInstance();              String path="D:/MS ACCESS DATABASE/mydatabase.mdb";              conn = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver  (*.mdb)};DBQ="+path+";","","root" );              Log.w("Connection", "open");              Statement stmt = conn.createStatement();              ResultSet reset = stmt.executeQuery("select * from tblEmp");

while executing this i'm getting following error on my log-cat

10-25 11:31:40.545: W/Error connection(422): sun.jdbc.odbc.JdbcOdbcDriver

Please Help me to Solve this issue??

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

No comments:

Post a Comment