ODBC Failure

HCL Domino Domino Forum
1

Can someone tell me why I’m getting this error? @Db function failed because the data type of the requested column is unsupported.

I have this code in a Dialog List w\ Use formula for choices.

classcache := “ODBC” : “NoCache”;

dns_name := “CAP_CONN”;

user := “CAP_CONN”;

pwd := “XXXXXX”;

nulls := “Discard”;

sort := “ascending”;

table := "dbo.tblCap ";

col := “CapName”;

tmp := @DbColumn(classcache; dns_name; user; pwd; table; col : nulls; “Distinct” : sort) ;

@If(@IsError(tmp);tmp;tmp)

2

Subject: ODBC Failure

Did you check what the datatype of the column “CapName” is? And what values do the documents have in this column?

3

Subject: RE: ODBC Failure

They’re text values, a list of vendors, why?