revOpenDatabase (ODBC) failing with no error on Ubuntu 18
Posted: Fri Mar 11, 2022 11:44 am
I'm a linux newbie (but don't think that's the issue here).
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
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