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

Ingela Anderton Andin <>
Fri Dec 9 15:56:45 CET 2011


It seems to be a missing feature. Support for the data_type SQL_GUID is 
not implemented.
I do not think it would be all that hard to implement but will not be 
highly prioritized by Ericsson.
Maybe somebody would like to make a user-contribution?! You should start 
looking at the
funtion encode_data_type in odbcserver.c

Regards Ingela Erlang/OTP team - Ericsson AB

Boris Mühmer wrote:
> 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
> _______________________________________________
> erlang-bugs mailing list
> http://erlang.org/mailman/listinfo/erlang-bugs

More information about the erlang-bugs mailing list