Odbc to sql server: how can I get the uniqueidentifier column?

HCL Domino Domino Forum
1

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 …

when i try to read that column with result.getvalue(columnno) I get the error:

621 LS:DO- Cannot convert data from native to expected or requested datatype.

It would be quite hard 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.

Thanks in advance for any help

Uwe

2

Subject: odbc to sql server: how can I get the uniqueidentifier column?

In SQL server data type of “uniqueidentifier” column is 16 byte long binary. To read this value using LSDO try setting result.FieldExpectedDataTyp as SQL_LONGVARBINARY.

You can find sample code at:

http://mail.mardi.my/help/help8_designer.nsf/f4b82fbb75e942a6852566ac0037f284/98752af64e8a0d948525731b004b5d7a?OpenDocument

Regards,

Litty Joseph