revdberr invalid database connection

[Pistris]

The simulator and the actual iphone are giving me this error when trying to make the connection to the database.

revdberr invalid database type

My database is the mysql service that comes with the livecode hosting
i can run the app fine from my mac and from my pc, but simulator and phone gives the error

i have checked the Mysql external under standalone application settings

the line of code am using is

put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult

My LC version is 7.1.0 Indy and Xcode 6.4

Another thing to note is that it gives me the error while disconected from the internet also , so something is happening before even trying to connect


going crazy here

[zaxos]

disable antivirus/firewall maybe? just athought

[Pistris]

???

Antivirus or firewall in my iphone?

[Klaus]

Hi Pistris,

try with LOWERCASE as indicated in the dictionary:
...
put revOpenDatabase("mysql", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
...

Best

Klaus

[Pistris]

It does not work in lowercase either

[zaxos]

Sorry i missed the mobile part, i'm a lazy reader.

[Simon]

Hi Pistris,
Any chance you forgot to tick the MySQL box in the standalone builder?

Simon

[Pistris]

No, i didnt forget

I rolled back to 7.0.6 and xcode 6.3 and it works perfect so its definitely a bug.

[SChamblee]

I have same issue, It works on PC, MAC and Android but gives an error on ios. I'm using LIveCode 7.1 (dp1)

[SChamblee]

I got the same results as Pistris, Install LiveCode 7.0.6 and Xcode 6.3 and it worked on ios.

[Dixie]

I have no problem connecting to a database here...
liveCode 7.1(rc1), xCode 6.4

a snippet of the script being used...

Code: Select all

local theDataRef

on mouseDown
   get revOpenDatabase("mysql", "theDatabaseAddress", "theDatabaseName", "theDatabaseUser", "jtheDatabasePassword")
   put it into theDataRef
   get revDataFromQuery( tab, return, theDataRef, "SELECT * FROM playtimes ;")
   set the thePlayTimes of this stack to it
   revCloseDataBase theDataRef
end mouseDown

It works on the desktop, in the simulator and on the iPhone...

[Pistris]

Dixie are you using the bussines edition?

Am using the business edition
I haven't tried the community edition

[Dixie]

Community... but for all intents and purposes, they are the same... at the moment