NetSuite ODBC: “You Don’t Have Permission to Use ODBC.”

This article is relevant if you are trying to connect up to NetSuite’s ODBC system.

NetSuite ODBC Connectivity

Recently, we started to experience some permission issues with our NetSuite ODBC connections.  Strange, we have been working with ODBC for some time.  For example, reference our articles below:

  1. NetSuite Delivers on ODBC
  2. Connecting ODBC to Multiple NetSuite Accounts
  3. NetSuite 64-bit ODBC Setup Instructions
Yet, most of the accounts we work with our development in nature and this is where we tripped up.    The good news is we started to work with Simon Miles at Solution 7 in the UK.  He has a wicked Excel based Financial Reporting add-in (we’ll write about it shortly) and he clued us into the recent service host changes.

NetSuite Offers Different ODBC Service Host Addresses

You may be getting a permission error when connecting to NetSuite ODBC.  This may have to do with the service host address.  Use these addresses to connect to specific environments:
  1. Production Accounts: odbcserver.netsuite.com
  2. Development / Test Drive Accounts: odbcserver.na1.netsuite.com
  3. Sandbox Accounts: odbcserver.sandbox.netsuite.com

Related Articles

  1. NetSuite Updates ODBC to Support 64-Bit Drivers
  2. NetSuite Delivers on ODBC
  3. SQL Reporting on NetSuite Data Step-By-Step
  4. Connecting ODBC to Multiple NetSuite Accounts
  5. NetSuite 64-bit ODBC Setup Instructions
  6. Extract NetSuite Data for Backup and Reporting
  7. Warning: SQL Server Linked Server to NetSuite Issues
  8. Considering Producing NetSuite Financial Statements using Third Party Tools?
If you need help working with ODBC on NetSuite to drive enhanced reporting, contact us.
Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - Google Plus - YouTube

| Tags: , , , , , | Category: NetSuite, Reporting | 4 Comments

2 Comments

  1. Mitisha Mehta
    Posted June 30, 2016 at 10:27 pm | Permalink

    Can we use stored procedure?

  2. Posted July 4, 2016 at 5:18 pm | Permalink

    Hi Mitsha,

    NetSuite’s ODBC system is read only and does not support stored procedures.

    Marty

2 Trackbacks

  1. […] NetSuite ODBC: “You Don’t Have Permission to Use ODBC.” […]

  2. […] NetSuite ODBC: “You Don’t Have Permission to Use ODBC […]

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>