dpeadmin
asked on
ODBC connection from Lotus Notes to SQL 2000 db.
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
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")
ASKER
Thanks SysExpert. This put me somewhat in the right direction.
I've successfully got Notes to do a dbcolumn lookup to a field containing data type = "char". This still leaves me with the issue that the data I want to retrieve from the table is of type "nvarchar". Is Notes unable to handle this data type?
I've successfully got Notes to do a dbcolumn lookup to a field containing data type = "char". This still leaves me with the issue that the data I want to retrieve from the table is of type "nvarchar". Is Notes unable to handle this data type?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Excel will change the type on the fly based on the data, Notes will not.
I hope this helps !