Odbc to sql server: how can I get the uniqueidentifier value(data type -11)?

Hi all,

I am reading data from an sql server, but cannot retrieve the column value of the uniqueidentifier - this data type (-11) seems not to be supported by LS:DO … it is even not listet in the data type constants.

when i try to read that column with result.getvalue(columnno) I get only a “false” as value.

(in an excel file importing the data via ODBC the data is shown correctly).

At the moment i am doing it on a 7.0.3 server, but I have not found any info that anything has changed with R8 (and my designer 8 do not show any data type -11 either, in the ODBC lib)

It’s impossible to ask the sql people to create new views for every data access I need - so I must find a way to get it from the existing ones.

Would be so great if I could find any solution

Uwe