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!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Make Your Voice Heard: What Tech & ERP Topics Should We Explore in our Next Webinar?? We’re all ears! Vote now, and the poll runs until January. Poll for ERP | Poll for Tech.
Uncover the power of data with the Analytics Hub —your ultimate guide to mastering NetSuite Saved Searches and Reports. Simplify the complex and unlock your organization's true potential. Dive into the Analytics Hub now and soar to new heights!
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