NetSuite 64-bit ODBC Setup Instructions

In my article NetSuite Delivers on ODBC, discussions have helped a number of NetSuite Administrators get ODBC connected. Yet, with Windows 7 (and possibly Windows Eight) growing in popularity including 64 bit machine architectures, the setup is more complicated.  Normally, you need to go to NetSuite Support to get the instructions.  I am including them here because at the time of this writing, it is not clear how to perform the setup from their instructions.

Download DataDirect 64bit Drivers

The NetSuite ODBC driver leverages the DataDirect ODBC driver set.  Download the 7.0 drivers here and install them on the target 64 bit machine.

Add NetSuite License File

NetSuite will provide you with a oaodbc64.lic file that will replace the evaluation version located at the Program Files > DataDirect > oaodbc700 file directory.  Given this license file is proprietary, I will not post it here.  However, contact me and I can provide you the license file.

Configure the ODBC Configuration

Here is where it gets a little tricky.  You will need to define an ODBC connection manually.  Here is what you need to do.

  1. Run %windir%\system32\odbcad32.exe to start the Windows Data Sources (ODBC) manager.
  2. Select a User DSN or System DSN and then click Add.  You should be presented with a dialog  as illustrated.  Select the DataDirect driver.
  3. Include the following information parameters. The key components are the Service Host (varies if you are trying to get to the Production or Sandbox environments), the Service Port (1708) and the Service Data Source (“”). ¬† See dialog.
  4. Select the Security tab and turn on Encrypted SSL. See dialog.
  5. Finally, Test Connect and you should be prompted for a user name and password.

Related Articles

  1. Resolving ODBC 64 bit Driver References
  2. SQL Reporting on NetSuite Data Step-By-Step
  3. Connecting ODBC to Multiple NetSuite Accounts
  4. NetSuite ODBC: ‚ÄúYou Don‚Äôt Have Permission to Use ODBC.‚ÄĚ
  5. Extract NetSuite Data for Backup and Reporting
  6. Warning: SQL Server Linked Server to NetSuite Issues
  7. Considering Producing NetSuite Financial Statements using Third Party Tools?
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 setup a conversation.

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

| Tags: , , , , | Category: NetSuite, Reporting, Technical | 18 Comments


  1. Posted September 7, 2012 at 4:29 am | Permalink

    Hi Marty:
    We deploy a complete virtualized business (VM) application for inventory planning. It includes the OS which is Linux. I noticed these instruction are for Windows, do you know if there is an Linux driver for the Oracle connection?

  2. Posted September 10, 2012 at 1:51 pm | Permalink

    Hi Rich,

    That is a great question. It looks like DataDirect offers a Linux driver. See this link:

    I suspect it will work. Yet the one challenge may be that NetSuite License File if it is not cross-platform. Do let me know how it goes.


  3. Posted September 10, 2012 at 3:20 pm | Permalink

    One other consideration when working with the NetSuite 64-Bit driver. It requires that you work with the MS Office 64-Bit version. You can not use MS Office 32-Bit against the NetSuite 64 Bit ODBC Driver. You will get a “The Specified DSN contains an architecture mismatch between the Driver and Application” error message.

  4. Posted September 19, 2012 at 6:05 am | Permalink

    Thnaks Marty for the resposne. We’ll take a look and let you know.


  5. jeff drazan
    Posted March 11, 2013 at 12:45 pm | Permalink

    Hi Marty

    I am looking to hire a strong programmer to do ODBC extracts from Netsuite.

    Either a very strong consultant or someone who is looking for a career beyond just writing drivers.

    I have full time and 6-12 month contract work available.

  6. Posted March 15, 2013 at 7:35 am | Permalink

    Hi Jeff,

    We can help. Let’s setup a conversation. I sent you a direct email.


  7. Mike Murray
    Posted May 2, 2013 at 7:47 am | Permalink

    Is getting data out of NetSuite – the so called “who owns the data” issue still relevant these days?

    We are considering implementating NetSuite but are concerned that we could be locking ourselves into a long-term commitment even though the contract would only be 3 years.

  8. Posted May 6, 2013 at 7:40 am | Permalink

    Hi Mike,

    I think this may be off topic. Have you seen this article however that addresses your concern?

  9. Abe
    Posted July 23, 2015 at 1:44 pm | Permalink

    I have installed license version of data direct odbc driver and created user DSN. I am trying to connect to Netsuite sandbox through SSIS and read the data to load into my SQL server table?
    Getting the error message The specified DSN contains an architecture mismatch between the driver and application.

    Any help is highly appreciated.


  10. Posted July 24, 2015 at 6:32 pm | Permalink

    Hi Abe,

    I suspect you are using or referencing the wrong ODBC driver. Meaning, you may be using the 32 bit driver on a 64 bit workstation. It’s easy to be confused. You may want to reach out to NetSuite Support.


  11. Kelvin
    Posted September 9, 2015 at 12:36 pm | Permalink

    Can I use jdbc-odbc bridge connection?

  12. Posted September 10, 2015 at 8:08 am | Permalink

    I haven’t tried it. But a Java application should be fine using it.

  13. Anshul Gupta
    Posted January 26, 2017 at 4:55 pm | Permalink

    Hi Marty,
    We are trying to connect to netsuite using JDBC ODBC driver.
    There are no inherent drivers from netsuite to accomplish this.
    Do you have any suggestions or drivers and how can we achieve this?

  14. Posted February 5, 2017 at 10:59 am | Permalink

    Hi Anshul,

    Are you using NetSuite’s ODBC? From a Windows Perspective, from Java, you can connect to generic ODBC resources. Have you tried that manner?


  15. Anshul
    Posted February 5, 2017 at 11:16 am | Permalink

    Hi Marty,
    Thanks for your answer however Netsuite now has a JDBC driver so we can directly consume it in our Java based programs

3 Trackbacks

  1. […] 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. […]

  2. […] operating system. ¬†The natural inclination is to want to use a 64 bit ODBC driver. ¬†I offer the 64 bit NetSuite license key with instructions here for the driver. ¬†However, I believe many do not need […]

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>