Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

How To Setup ODBC CS / Client Server For Sage 100 ERP Advanced (Formerly MAS 200)

July 17, 2012 by Wayne Schulz

If you are using Sage 100 ERP Advanced (formerly Sage ERP MAS 200) you may be able to speed up reporting times for Crystal based reports by installing a client server ( CS ) ODBC driver.

The Client Server (CS) ODBC Driver allows workstations to print Crystal forms and reports using server-side ODBC processing. This option is available in Sage 100 ERP Advanced (formerly  Sage MAS 200) 4.10.1 and later.

The CS ODBC Driver has been tested and designed for use with Crystal reports and forms printed through the Sage 100 ERP Advanced (Formerly Sage MAS 200) Business Desktop (Launcher). It has not been tested for use with other ODBC applications (for example, SQL Server queries and Access queries). Sage Software does not support the use of other ODBC applications that may attempt to use the CS ODBC driver.

CS ODBC Driver is only 15 users (4.40 and less) and have heard this with those encroaching 15. At present there is no command to display available license slots.

There are some setup instructions which thankfully Sage have created a greatly simplified “how to” guide for (see link below) as well as a more advanced guide (also linked below).

The limitation to this driver is that it only supports 15 concurrent users and there’s no guarantee or support by Sage for using the

Version 4.5 introduced a new ODBC CS driver which may have increased the concurrent user capacity to 50.

How to setup a client server ODBC data source for Sage 100 ERP Advanced (formerly Sage ERP MAS 200)

Advanced How to setup a client server ODBC data sources

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: Client Server, CS, odbc

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?
  • Payroll Requirements for Year-End 2023
  • DataSelf ETL+ v2023.07 for Sage 100 Announced
  • Version History of Sage 100 Accounting Software
  • What Happens if Sage 100 Goes Read-Only?
  • Sage 100 Knowledgebase Updated
  • Top Sage 100 New Features – Versions 4.4 through 2023
  • The Wayfair Ruling at Five: Why 72% of Businesses Still Struggle with Economic Nexus
  • AVALARA UPDATE: Sales Tax Holiday Changes in Florida
  • Sage 100 & CRM – May 2023 Update

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter
Schulz Says Email NewsletterSent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.

 

Loading Comments...
 

You must be logged in to post a comment.