Android Question android > 4.0 NetworkOnMainThreadException error help

[Spinter]

I'm using HttpRequest to communicate with my mysql but with a device SDK 2.2 everything works perfectly! device with a 4.0 sdk I go to NetworkOnMainThreadException.
How do I get out?

 

[Kevin]

Use HTTPUtils2 instead...

http://www.b4x.com/android/forum/threads/httputils2-web-services-are-now-even-simpler.18992/#content

 

[B4A Enthusiast]

Hi, am facing an interesting situation; when i run my app in debug(rapid) mode it runs okay.
When i run in Release mode, it brings an error when I press the Login button. The error is:

"An error occured in sub: android.os.NetworkOnMainThreadException"

The entire Login Button Click Event Code is as follows:

Dim rows As Int,strPass As String
    Dim a As MSSQL, L As List

    a.setDatabase("192.168.1.2","DBNAME","username","pswd")

    strPass = ModuleEncrypt.RC4(txtPassword.Text, "PUBLIC_KEY")

    L=a.Query("select * from Passwords Where UserName = '" & txtUserName.Text & "' And Password = '" & strPass & "'")

    If L.IsInitialized=False Then
        Msgbox("YOUR CREDENTIALS FAILED TO AUTHENTICATE","PLEASE TRY AGAIN!")
    Else
        If L.Size>0 Then
  
            rows = L.Size
      
            If rows=1 Then
                Msgbox("YOUR CREDENTIALS FAILED TO AUTHENTICATE","PLEASE TRY AGAIN!")
            Else
                IME1.HideKeyboard
                Activity.RemoveAllViews
                MyPhone.SetScreenOrientation(-1)'Release Orientation
                Activity.LoadLayout("SectionChoice")
                FormatSectionChoiceViews
                DoEvents
            End If
        Else
            Msgbox("Sorry, Authentication Failed." & CRLF & "Please Try Again","INVALID USER DETAILS")
        End If
    End If

Please help me out - have scratched my head enough times!
Thanks.

 

[Erel]

You should not use this library as it manages the communication over the main thread. You should instead use RDC or the ASP .Net solution.

 

[B4A Enthusiast]

Okay Erel. Well put.

I followed your advise and decided to go the RDC way. Am however unable to setup the RDC Server Successfully.
Am getting the attached error.

What is it that am not doing correctly? Thanks.

 

[Erel]

Can you post your config file?

 

[B4A Enthusiast]

Sure, here is my config file

However inside the jdbc_driver folder there is a conf folder in which I changed the settings as follows:

Advise Erel...

 

[Erel]

Try to use the jtds driver. See the commented driver configuration: http://www.b4x.com/android/forum/th...ector-connect-to-any-remote-db.31540/#content

You also need to make sure that the db server is configured to accept connections.