[achandlerworth@dwr.com]

When using Netsuite’s DataDirect OpenAccess SDK 7.0 client for ODBC 64-bit, configured as a linked server in SQL server, has anyone encountered these errors,

OLE DB provider “MSDASQL” for linked server “LINKEDSERVERNAME” returned message “Requested conversion is not supported.”.

Msg 7341, Level 16, State 2, Line 1

Cannot get the current row value of column “[MSDASQL].NETSUITEFIELDNAME” from OLE DB provider “MSDASQL” for linked server “LINKEDSERVERNAME”.

So far it appears to only be happening with Custom fields of type ‘long text’ but I can not confirm this since I can’t find a list of all standard fields and their type the same way you can look up custom fields.
This is a cached copy. Click here to see the original post.

[rnedelkow]

This is mentioned in SuiteAnswers Answer Id: 24833. The answer suggests using to_char to get around this:

Example:

Given linked server NETSUITE_LS and custom long text field CUSTOM_DESCRIPTION in transactions table

OPENQUERY(NETSUITE_LS,’SELECT to_char(i.[CUSTOM_DESCRIPTION]) AS “CUSTOM_DESCRIPTION” FROM TRANSACTIONS’)

[achandlerworth@dwr.com]

That’s it. Thank you!

[Author]

Posts