I've posted this already on the Linux board, but no replies.
My first question is really whether anyone has succesfully accessed a database over ODBC on Linux?
Details:
I'm trying create a LiveCode app (currently using LC 9.6.6) to run on Linux (currently targeting Ubuntu 18) which needs to read from a database over ODBC.
I have a working ODBC connection, tested with isql.
When the LiveCode app executes revOpenDatabase however, it returns an empty string. Not a connection id; not an error message.
Two questions:
1) Has anyone else successfully accessed ODBC data source from LiveCode on Linux?
2) Is there some obscure console or other place I might look to see if there are any clues to what's happening, given that revOpenDatabase isn't returning any info?
TIA,
Ben
Can't use ODBC on Linux - no error reported
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Can't use ODBC on Linux - no error reported
No idea if it will help, but have you tried connecting inside a try/catch block? Might give more error info...
Stam
Stam
Re: Can't use ODBC on Linux - no error reported
Hi stam, thanks for replying.
Good idea but the whole function is in fact running inside a try-catch block, and unfortunately it doesn't throw any error - revOpenDatabae just returns an empty string.
Good idea but the whole function is in fact running inside a try-catch block, and unfortunately it doesn't throw any error - revOpenDatabae just returns an empty string.