I'm currently developing a application based in Rcode, ODBC and Firebird.
For that, first I've installed firebird server and unixODBC (both 64 bits since my machine OS is 64-bits). I tried with 32-bits software aswell since Ubuntu multiarch allow it, but that caused another problem (doesnt matter in this subject).
Created database, using firebird isql function (/opt/firebird/bin/isql), and made some fake tables with integer, float, text columns.
I can connect to it using unixODBC isql function (after properly programming DSN and Driver in odbc.ini / odbcinst.ini), but theres a problem:
I can't select tables containing text columns, it gives error std::bad_alloc
After some research, I've discovered slencheck function from unixODBC, using it on my driver returns
slencheck: sizeof(SQLLEN) == 4 slencheck: driver manager and driver differ!!!
How can I modify unixODBC SQLLEN so it became compatible with 64-bits Firebird ODBC driver?
I can't select text columns because of SQLLEN or there's more to this? I think this odbc's github issue is related to mine