Search code examples
androidsql-serverjtds

how to connect sql server using JTDS driver in Android


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

thnx in advance...


Solution

  • 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.