Page 1 of 1
revdberr invalid database connection
Posted: Wed Aug 12, 2015 7:11 am
by 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
Re: revdberr invalid database connection
Posted: Wed Aug 12, 2015 10:29 am
by zaxos
disable antivirus/firewall maybe? just athought
Re: revdberr invalid database connection
Posted: Wed Aug 12, 2015 3:26 pm
by Pistris
???
Antivirus or firewall in my iphone?
Re: revdberr invalid database connection
Posted: Thu Aug 13, 2015 11:01 am
by Klaus
Hi Pistris,
try with LOWERCASE as indicated in the dictionary:
...
put revOpenDatabase("mysql", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
...
Best
Klaus
Re: revdberr invalid database connection
Posted: Fri Aug 14, 2015 5:17 am
by Pistris
It does not work in lowercase either
Re: revdberr invalid database connection
Posted: Sat Aug 15, 2015 5:33 pm
by zaxos
Sorry i missed the mobile part, i'm a lazy reader.
Re: revdberr invalid database connection
Posted: Sat Aug 15, 2015 8:33 pm
by Simon
Hi Pistris,
Any chance you forgot to tick the MySQL box in the standalone builder?
Simon
Re: revdberr invalid database connection
Posted: Mon Aug 17, 2015 7:58 pm
by 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.
Re: revdberr invalid database connection
Posted: Sun Aug 23, 2015 12:47 am
by 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)
Re: revdberr invalid database connection
Posted: Sun Aug 23, 2015 5:11 am
by SChamblee
I got the same results as Pistris, Install LiveCode 7.0.6 and Xcode 6.3 and it worked on ios.
Re: revdberr invalid database connection
Posted: Sun Aug 23, 2015 11:36 am
by 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...
Re: revdberr invalid database connection
Posted: Sun Aug 23, 2015 6:59 pm
by Pistris
Dixie are you using the bussines edition?
Am using the business edition
I haven't tried the community edition
Re: revdberr invalid database connection
Posted: Sun Aug 23, 2015 7:50 pm
by Dixie
Community... but for all intents and purposes, they are the same... at the moment