[patwalsh82]

I have just downloaded the new Netsuite ODBC driver 6.0. I created a Linked Server in SQL Server 2005 and have been trying to run a simple query. Before, using version 5.5, the queries have been running perfectly. Now, I am only able to return the unique id from the NetSuite ODBC table. For instance, the below code will return this error:

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

Msg 7341, Level 16, State 2, Line 2

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

Code:
SELECT q.[ACCOUNTING_PERIOD_ID],q.[NAME] from OPENQUERY(NETSUITE,’
SELECT p.[ACCOUNTING_PERIOD_ID],p.[NAME]
FROM [Administrator].ACCOUNTING_PERIODS p
order by [ACCOUNTING_PERIOD_ID]
‘) q
But, removing the ‘name’ column from the query and just returning the unique id, would work successfully. Does anyone have an idea to get the query to work? I have tried converting the column with ‘text’, ‘varchar’, ‘nvarchar’…
This is a cached copy. Click here to see the original post.

[mhuffman]

Please file an issue with support… it sounds like something we will need to get investigated by the vendor who supplies our ODBC driver.

[redfox]

RE: NS ODBC Driver: ‘Requested conversion is not supported’

Hi Patrick,

Can you please try to check the properties of MSDASQL

1. Expand the Providers menu tree> Right click the MSDASQL and set these options:[*] Dynamic parameter[*] Nested Queries[*] Allow inprocess[*] Supports ‘Like’ operator

[patwalsh82]

Thanks but i tried this and it didnt work. Still get the error message.

[julio.bonilla@eset.com]

We found that ODBC driver doesn’t support clob datetypes from Netsuite. I should say SQL Server doesn’t support the CLOB because string limitations. This might be the issue you are having.

[Author]

Posts