In this tip, I have focused on troubleshooting some of the common Netsuite Odbc connector issues.
I was trying to connect Excel sheet via NS Odbc connector, using my NS SDN account and some other production account also but, I went through a handful of issues before making it work perfect, however. In NS help center you can find many solutions to this problem but there are few which are not mentioned in it. And in here I’m trying to explain those.
Prerequisite:- – NS account must be supporting the ODBC feature. – Download the ODBC connector from NS home page. You can get more details on it in the NS help center.
Is it the default account?
You need to make sure that the account which you will be using to connected from ODBC should be the default account in your user login access for NS. Because when you will provide your login credential, connector will look only for the default account, even if your other accounts in that login credential might have ODBC feature enabled in it.
Are you using a SDN account?
If your are using a NetSuite SDN account then you will need to change the host of your NS Odbc DSN.
Windows Start> Control Panel>Administrative Tools>Data Sources (ODBC)
Here the “ODBC Data Source Administrator” window will open, inside that you will find the “User DSN” tab. Again in this tab you will see a DSN named as “NetSuite.com”[it’s the default name], clicking this will open the “DataDirect OpenAccess SDK ODBC Driver Setup” window. Here you can change the host of the connector. Or you can create a new DSN with selecting “NetSuite ODBC Driver 6.0” as its Data Source [“6.0” is the current version for now]. By default the host will be “odbcserver.netsuite.com” but you should change it to “odbcserver.na1.netsuite.com“.
Error: ‘This data source contains no visible tables.’? Are you facing the ‘This data source contains no visible tables.‘ error after the login is success? If so, then you would need to select the “System Tables” check box in the “Options” dialog.