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

Created
October 08, 2021 23:25

Date Posted: 2018-07-17
Product: TIBCO Spotfire®

Problem:

Solution:

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.
============================================== 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. https://docs.oracle.com/cd/E60665_01/netsuitecs_gs/NSALC/NSALC.pdf