Thursday, September 20, 2018

Create a new DSN using Netsuite ODBC Driver 6.0 for Release Preview accounts?

A user would like to create or add a new DSN using Netsuite ODBC Driver 6.0 for his Release Preview account. He used the Data Sources tool of Windows to do this but was unable to add/configure the existing NetSuite.com DSN.
 

1. If using SQLDbx as a query tool. Download SQLDbx first. Click Here
2. Login to any account which has ODBC activated.
3. Go to Tools > ODBC Administrator.
4. On the User DSN Tab, click Add button.
5. Search for Netsuite ODBC Driver 6.0 on the driver list and Click Finish.
6. Provide the same details indicated below for a Release Preview account:
 
Data Source Name: NetsuiteRP.com
Description: NetSuite.com ODBC Access
OpenAccess Service Host: odbcserver.na1.beta.netsuite.com
Port: 1708
OpenAccess Service Data Source: NetSuite.com
Encrypted(SSL)=checked

 
7. Click Ok and then try to login to the Data Source using SQLDbx or any query tool using your email and password.
 
 
 

No comments:

Post a Comment