I'm tring to get a keyword list in Notes (V5.5) using ODBC to connect to table in SQL 2000 DB. I've setup the ODBC connection in Data Source Admin (WinXP SP2).
In the Notes form I'm getting this error consistently when clicking into the field doing the @dbcolumn lookup, regardless of which DB I'm trying to access "@db function failed because the data type of the requested column is unsupported".
Using the same ODBC connection I can successfully bring external data into Excel for example.
The versions of ODBC drivers on my PC are:
SQL Native Client 2005.90.3042.00
SQL Server 2000.85.1117.00
The code in the field is:
@DbColumn("ODBC":"Cache"; "MyDataSourceName"; "";""; "dbo.MyTable"; "MyField": "Discard" ;"Distinct" : "Ascending")