On x86_64 arch the "odbcserver" helper executable (should be located at erlang/lib/odbc<version>/priv/bin after installation), which is required for proper ODBC operation, is not compiled by default, thus resulting in missing ODBC support in erlang. It's not clear why is it disabled on x86_64, as after enabling its compilation everything seems to work OK (tested with ejabberd + MySQL + MyODBC). See https://bugzilla.altlinux.org/show_bug.cgi?id=12576 for similar bug-report in ALT Linux and some additional information - discussion is in Russian, but the conclusion is that it also worked there after uncommenting odbcserver compilation. Reproducible: Always Steps to Reproduce: The patch for enabling "odbcserver" compilation is attached.
Created attachment 135394 [details, diff] This patch enables odbcserver compilation on x86_64 platforms
Patch sent to upstream with question why this was actually disabled...maybe there was a reason and we cannot foresee it at the moment. Thanks for the notice however.
Thanks for the contribution and research. Upstream answered as following: "The only reason is that we do not have a test environment where we can verify that it works. To the best of my knowledge the code does not do anything that is unportable to a 64-bit architecture. We could upgrade our test environment but as we have no funding for supporting odbc on 64-bit architecture so the priority of this is very low. However I think it would be reasonable that we remove the disabling from the make file now that we know that it does work. I can not promise but I will take it up with the project management." -r3 added to the repository, don't expect it to be stable, as I will go straight for R12.
(In reply to comment #3) > Thanks for the contribution and research. Upstream answered as following: > > "The only reason is that we do not have a test environment where we can > verify that it works. To the best of my knowledge the code does not do > anything that is unportable to a 64-bit architecture. We could > upgrade our test environment but as we have no funding for supporting > odbc on 64-bit architecture so the priority of this is very low. However > I think it would be reasonable that we remove the disabling from the > make file now that we know that it does work. I can not promise but I > will take it up with the project management." > > -r3 added to the repository, don't expect it to be stable, as I will go > straight for R12. > A shell account is available on pitr.amd64.dev.gentoo.org to upstream developers of packages in our tree. Please contact pitr-admins@g.o for more details.
(In reply to comment #4) > A shell account is available on pitr.amd64.dev.gentoo.org to upstream > developers of packages in our tree. Please contact pitr-admins@g.o for more > details. I told upstream about it, thanks for the notice. But I am surprised that Ericson (Erlang upstream) has no money for a 64bit system.