Android Question mysql connection problem

Discussion in 'Android Questions' started by 3394509365, Apr 18, 2019.

  1. 3394509365

    3394509365 Active Member Licensed User

    Hi I'm trying to connect to my sql server from android. I am at the beginning, that is, with the connection and I am already at rest
    I wrote this with my credentials but it never initializes

    Sub Button1_Click
    Dim db As MYSQL
    Dim L As List
    db.setDatabase("LAPTOP-33333333","SQLTutorial","pippo","pippo")

    L = db.Query("Select * FROM Products")
    If L.IsInitialized=False Then
    Msgbox("Records Not Found","Warning")
    Return
    Else
    For i = 0 To L.Size
    ListView1.AddSingleLine(L.Get(i))
    Next
    End If
    End Sub
     
  2. DonManfred

    DonManfred Expert Licensed User

    1. Use jdbcsql. See similar threads above
    2. I guess you need to use the server ip instead of a pcname
     
    Didier9 and Erel like this.
  3. 3394509365

    3394509365 Active Member Licensed User

    I use Basic4A I downloaded the JdbcSQL.jar library but I don't load it between libraries.
    I have version 3.20 of Basic4Android

    Does anyone have an example in my version?
     
  4. DonManfred

    DonManfred Expert Licensed User

    You B4A Version is 6 Years old. I STRONGLY suggest to update to the newest.
     
  5. 3394509365

    3394509365 Active Member Licensed User

    io non sono uno sviluppatore, ma un dilettante, e mi piace l' informatica non devo fare niente di commerciale.
    Uso basic4android per le mie app personali.
    Se non fosse indispensabile continuerei ad usare questo. Poi, se invece, per quello che devo fare mi serve per forza la nuova versione allora hai ragione, serve quella nuova. Cosa mi dici?
    Grazie
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice