Any luck connecting to PostgreSQL or MYSQL on Linux using Christian’s SQL Database Plugin?
I’ve got CubeSQL,SQLite and Microsoft SQL working well, but am struggling with the last two (the most important two in my opinion).
MSSQL
I was able to get this working for Windows (no plugin needed) and macOS (using and IP address and Christian’s libtdsodbc.dylib file, but not Linux (even with Christian’s libtdsodbc.so file).
PostgreSQL
This is working for Windows (needs libpq.dll file), for macOS (needs a special version of libtdsodbc.dylib as the normal version fails AppStore submission) and for Linux (needs the three files: libcrypto.so.1.0.0, libpq.so.5.6 and libssl.so.1.0.0).
Well, first is to either use libraries you provide, the linux distribution provides or the built-in.
e.g. for PostgreSQL I made the InternalPostgreSQLLibraryMBS module and it should come with Linux.
On the website I also have a collection of various Library files:
I’ll hunt for the Linux Postgres libraries online. They aren’t in that link you referenced.
Also that function you reference has a warning on the page: “This item is deprecated and should no longer be used. You can use postgres driver libraries instead.”