Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

ODBC Crystal Reports driver - does not look accurate?

Posted By Biotone over 8 years ago

I have reports that when I go into designer I see the ODBC connection and it not using the SOTAMAS90 ODBC connector, it has some other type of connection. I do not think it is correct and if someone can explain the connector and how to fix it I would appreciate any help?

Ervery report I try to fix or change has this type of Driver?

ODBC.docx cid:image004.jpg@01D13CC6.654D4910

0 TomTarget over 8 years ago

That's legit. No worrys.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Biotone over 8 years ago in reply to TomTarget

Ahh, that a great answer. Thanks for your assistance Tom.

I asked to have this explained, I understand it works.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jcnichols over 8 years ago in reply to Biotone

Hi, Starting with the 5.0 release (2013) all Sage 100 reports utilize a connection string to the ODBC driver. In the attached screen shot the connection shows the ODBC connection string "Driver = {MAS 90 ODBC Driver}, etc". The SOTAMAS90 DSN was retained for backward compatibility with user defined reports. Please let me know if you need a more in-depth explanation.
John Nichols
Sage
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

ODBC Crystal Reports driver - does not look accurate?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING