Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Netsuite ODBC Connection Error

KevinF
5 - Atom

The attached error occurs when attempting to establish a connection to Netsuite.  The error doesn't occur when logged in directly to the Alteryx Server.  The error only occurs when we are attempting to establish a local connection using the Gallery.

1 REPLY 1
ntobon
Alteryx
Alteryx

I have done a google search and found this post with similar error:  
https://www.reddit.com/r/Netsuite/comments/dlq1qo/odbc_connect_error/

 

It says:

"If you used the bundle, the dsn maybe trying to connect as role id 3 for administrator. You may have to override it to make sure the role id is the correct internal id for the role you’re using"

and the user responded:
"Thank you! This was it. I installed the connector using my NetSuite login and the role defaulted to the admin role ID. Once I updated this to their ID it worked!"

 

Can you check if that is what you is causing your issue?

Labels
Top Solution Authors