LiveCode Forums.

Using LC 7.1

Why does the connect button for "Connecting to a MySQL database" work from my laptop, but not when I test it with the android simulator?

The code for my button is below:

on mouseUp
  -- use a global variable to hold the connection ID so other scripts can use it
    global gConnectionID
    
    -- set up the connection parameters - edit these to suit your database
    put "runrev.com" into tDatabaseAddress
    put "runrev_test" into tDatabaseName
    put "runrev_example" into tDatabaseUser
    put "example" into tDatabasePassword
    
    -- connect to the database
    put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
    
    -- check if it worked and display an error message if it didn't
    -- & set the connection ID global
    if tResult is a number then
        put tResult into gConnectionID
        answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID
    else
        put empty into gConnectionID
        answer error "Unable to connect to the database:" & cr & tResult
    end if
end mouseUp

Thanks,

David

When I recently encountered something similar it was because I had forgotten to tick

Standalone Application Settings > Android > Application Permissions > Internet

Regards

Also, make sure the MySQL external is included in your standalone application settings-

Kind Regards,

Neil Roger
--
LiveCode Support Team ~ http://www.livecode.com
--

Neil,

Thanks,

David