how to connect sql server using JTDS driver in Android

Piyush picture Piyush · Oct 3, 2011 · Viewed 26.1k times · Source

i am new in android.. i want to connect sql server using JTDS driver. can any one tell me..

thnx in advance...

Answer

KumailR picture KumailR · Nov 22, 2012

Getting error "ClassNotFoundException" while using JTDS on ANDROID to direct access SQLSERVER?

After 3 hours RND, for finding solution for the same above error. I didnt get there is no error in the code, also I have import "jtds-1.3.0" library properly continues debugging of code still getting same error again and again.

{
 Class.forName("net.sourceforge.jtds.jdbc.Driver");

 Connection conn = DriverManager.getConnection(
 db_connect_string, db_userid, db_password);
}

I tried alternative to, changing line

...... Class.forName("net.sourceforge.jtds.jdbc.Driver");

to

...... (new Driver()).getClass();

...... (new Driver())

when I tried all of these, I tought there might be a problem in jtds-1.3.0 library, and what I did, just download the old version jtds-1.2.5 and import it; and the issue resolved.

So, friends out there If you getting same error and tried different ways already, try this.