Error While Connecting Oracle Netsuite to Spotfire: ERROR [HY000] An account must be specified in order to log-in to NetSuite. (HRESULT: 80131937)

Error While Connecting Oracle Netsuite to Spotfire: ERROR [HY000] An account must be specified in order to log-in to NetSuite. (HRESULT: 80131937)

book

Article ID: KB0081381

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

To connect to Oracle Netsuite via ODBC, Oracle NetSuite ODBC driver or any third party ODBC driver can be used like Cdata ODBC Driver, Devart ODBC Driver etc. While doing test connection for the created User DSN, following error message gets displayed

==============================================
ERROR [HY000] An account must be specified in order to login to NetSuite.
============================================== 

Issue/Introduction

Error While Connecting Oracle Netsuite to Spotfire: ERROR [HY000] An account must be specified in order to log-in to NetSuite. (HRESULT: 80131937)

Environment

All Supported Operating Systems

Resolution

To resolve this error, check whether the entered information of "account id" is correct or not. Below are the steps to check NetSuite account number:

1) Go to Setup > Company > Company Information.

2) Your account number will be listed under the Account ID field.

Additional Information

https://docs.oracle.com/cd/E60665_01/netsuitecs_gs/NSALC/NSALC.pdf