Why does the Mas90 ODBC Driver keep showing up in Sage Intelligence?

Posted By Terry Bumgardner over 5 years ago

We are having a problem with report totals doubling because the 'Mas90 4.0 ODBC Driver' driver keeps showing up as one of the connection types.

Example - The Tenant Viewer looks similar to the following listings -

TENANT, CONNECTION TYPE, DB SERVER, DB CATALOG, DB UID, DB PSWD

MAS_AII, ODBC Driver SQL Server, APPSERVER, MAS_AII, MAS_Reports, ************

MAS_RCS, ODBC Driver SQL Server, APPSERVER, MAS_RCS, MAS_Reports, ***********

MAS_MPL, ODBC Driver SQL Server, APPSERVER, MAS_MPL, MAS_Reports, **********

MAS_AII, MAS 90 4.0 ODBC Driver, APPSERVER, MAS_AII, MAS_Reports, *********

The last driver should not be included. Why is this happening? And what can we do to get rid of this issue?

Thanks,

Terry

0 TomTarget over 5 years ago

OK. I qualify as confused. I believe the ODBC driver is how Sage Intelligence accessed the data.

What or where is this Tenant Viewer? I can't claim that I have ever seen it. Maybe I will learn something new today?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 5 years ago in reply to TomTarget

I banged my head against this wall recently for a Premium customer. We basically had to scrub the workstation of all references to the Providex ODBC driver, so only the SQL connections existed. (It is workstation specific, so you can also try running SI from somewhere else).

I believe there is a KB article with some details too (how to reset and re-try).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Terry Bumgardner over 5 years ago in reply to Kevin M

I looked on the knowledge base and could find anything. Any suggestions on search criteria to find this article? Thanks for the help
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Terry Bumgardner over 5 years ago in reply to TomTarget

I'm not sure where the Tenant Viewer is. I'm researching this issue for a co-worker. The ODBC driver we want to use is an SQL driver. The Mas90 Driver is not required.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 5 years ago in reply to Terry Bumgardner
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Terry Bumgardner over 5 years ago in reply to Kevin M

Thank you sir!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Why does the Mas90 ODBC Driver keep showing up in Sage Intelligence?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING