Live code Server revOpenDatabase help needed

[Ralph DiMola]

Kevin,

I ran into this when I updated to 64 bit. It was a script only library
stack. I don't know why it worked in v6 but did not work in v9. For me it
was fastJson.livecodescript that caused the problem so I just used the built
json in v9 and all was OK. Why it showed up in a DB open is a mystery?
https://quality.livecode.com/show_bug.cgi?id=22514

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net


-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of kevin--- via use-livecode
Sent: Wednesday, July 15, 2020 6:08 AM
To: use-livecode at lists.runrev.com
Cc: kevin at stallibrass.com
Subject: Live code Server revOpenDatabase help needed

Hi,

I've been running a very old (32bit lc server v6 on Ubuntu 16) for years and
the following script works to connect to the SQL database.
My new(er) server (64bit lc server v9 on Debian 8) throws up ~Function:
error in function handler (revOpenDatabase)~ so something has clearly
changed. I've tried removing the socket references, changing the connection
type but the error message remains the same. Has the syntax for
revOpenDatabase changed and I'm reading old documentation again?

Thanks
Kevin

# connect to the database
command dbConnect
put "/var/run/mysqld/mysqld.sock" into _Socket
	put revOpenDatabase("MySql", "localhost:3306", _dbName, _dbUser,
_dbPass,, _Socket) into DB
	if DB is not a number then put "Error: could not connect to
database!" & BR end dbConnect




_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode