I am writing a commercial application in which i need to connect to an existing MySql database, my development machine is a Mac so I can adapt to IOS mobile if required in future.
So currently the application supports Windows and OSX which is perfect for the end users, however...... The code being used (Below) will not compile / accept a connection for either OSX or Windows once built as a standalone or even in the debug area within LC. I then switched to a Windows machine simply copied and pasted the below code, built a standalone for both platforms and it was successful for both.
Code: Select all
on mouseUp
global gConnectionID
put "Address" into tDatabaseAddress
put "Name" into tDatabaseName
put "User" into tDatabaseUser
put "Password" into tDatabasePassword
put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
if tResult is a number then
put tResult into gConnectionID
answer info "succefully connected!!" & cr & "Connection ID = " & gConnectionID
else
put empty into gConnectionID
answer error "Unable to connect." & cr & tResult
end if
end mouseUp
Any help would be appreciated.
Gary