Say you want to look at an item’s memo field but you can’t login to NetSuite as all the users license are taken.

The next best thing to do is do a query in MSSQL with a linked server connection NetSuite.  In the query window, you type the following.

select item_id, memo_field

from [SANDBOX].[YourCompany].[Administrator].[inventory_items]

where item_id = 44608

You get an error below.

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

Msg 7341, Level 16, State 2, Line 1

Cannot get the current row value of column “[SANDBOX].[YourComany].[Administrator].[inventory_items].memo_field” from OLE DB provider “MSDASQL” for linked server “SANDBOX”.

Look on line to find a solution to the error message but could not find one that would solve the error.

NetSuite has a solution to query. It’s DbVisualizer.  Download the version 9.2 or below.  Newer version of the DBVisualizer use Java 8 where JDBC/ODBC Bridge is no longer provided.  Once installed and configured.

Then enter query in the window as below and press the green arrow to run it.  The result is returned in second window below.  Note this is free version with limited function. Please visit the site for further information on the product. 

NetSuite NYC

Wait! Before You GoWould you like to talk to a business software expert to answer your questions?

When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.

Learn More