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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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