Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Community Poll: What sort of content would you like to see more of?

SuiteAnalytics Connect: How to resolve ODBC error when connecting to NetSuite Release Preview?

edited Mar 29, 2023 11:06PM in Ask A Guru 6 comments

We have SuiteAnalytics set up in all our NetSuite instances.

ODBC connections to NS-Prod, NS-SB1 and NS-SB2 are all working and successful. When attempting to connect to NS-RP is unsuccessful.

Validated that the ODBC connection for NS-RP successfully connects


When attempting to Get Data from ODBC through Excel receive the following on and off error messages:





From researching, I found that the ODBC version successfully running NS-Prod/NS-SB1/NS-SB2 is 8.10.143.0

Which is the same version in NS-RP SuiteAnalytics Connect Driver Downloads page


I have validated username/password, Host/Port/Datasource/account id/role_ID, (which gets changed to 1033 in the DNS).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 2 ((Apr-Jun 2024) )

This Week's Leaders

This Month's Leaders

All Time Leaders