[erlang-bugs] erlang/odbc <-> ms-sql error with 'uniqueidentifiers' (aka GUIDs): ODBC_UNSUPPORTED_TYPE

[Boris Mühmer]

I try to connect to one of our companies Microsoft SQL databases using
Erlang/OTP R14B04 running on an Ubuntu 10.04 64 Bit installation
(using the FreeTDS drivers from the Ubuntu repositories).

The problem I have is, that the Erlang ODBC module can't handle
'uniqueidentifier' (aka GUID) fields in tables. For example a 'select
*' doesn't work, but when I only select the non-uniqueidentifier
fields from the same table it works.

On the other hand, when I use the "isql" (commandline-)tool with the
same ODBC connection, I don't get any errors.

So I would say that something within the Erlang ODBC module is broken
(I believe it is in "odbcserver.c").

Is this a known bug, or did I miss anything?


Regards,
Boris