mySQL not working in standalone
Posted: Sun Feb 28, 2016 3:37 pm
Hello: I'm compiling a standalone using LC 5.5.1 and I can't connect to my mySQL database (remote). I selected "Select inclusions for the standalone application", checked "Database Support" and included "MySQL". When I connect using the following script, nothing happens. It seems like the database support inclusions aren't being saved into the standalone. ???
global gconnectionID
on mouseUp
put field "SQLdomain" on stack "settings" into tDatabaseAddress
put field "SQLdbaseName" on stack "settings" into tDatabaseName
put field "SQLuser" on stack "settings" into tDatabaseUser
put field "SQLpass" on stack "settings" into tDatabasePassword
-- connect to the database
-- Keep trying if you cant connect
repeat until tResult is a number
put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
put tResult into gConnectionID
put "trying to connect to SQL..." && tResult into field "thestatus"
end repeat
put "connected to SQL..." && tResult into field "thestatus"
end mouseUp
global gconnectionID
on mouseUp
put field "SQLdomain" on stack "settings" into tDatabaseAddress
put field "SQLdbaseName" on stack "settings" into tDatabaseName
put field "SQLuser" on stack "settings" into tDatabaseUser
put field "SQLpass" on stack "settings" into tDatabasePassword
-- connect to the database
-- Keep trying if you cant connect
repeat until tResult is a number
put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
put tResult into gConnectionID
put "trying to connect to SQL..." && tResult into field "thestatus"
end repeat
put "connected to SQL..." && tResult into field "thestatus"
end mouseUp