Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
NS ODBC Driver: 'Requested conversion is not supported'
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".
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
0