Can't use ODBC on Linux - no error reported
Posted: Fri Mar 11, 2022 5:39 pm
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
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