Schulz Consulting 833-724-3100

Sage 100cloud Consulting

  • Home
  • Services
  • Find A Local Sage Consultant
  • Contact Us
You are here: Home / Sage 100 ERP / How To Fix Sage 100 Database Connector Error 9 Problems

How To Fix Sage 100 Database Connector Error 9 Problems

March 29, 2016 by Wayne Schulz

odbc_error_9

The Database Connector Error 9 issue has been around at least since 2011 when we first wrote about this fix here.  In nearly every instance “database connector error 9” is referencing a badly formatted date.

For example, instead of storing a day 01/01/2016 Sage 100 may store it as 01/  /2016 which in turn triggers the database connector error.

The first thing many advanced users will try is to create a Crystal Report which pulls all the data from the affected table. At this point they are surprised to see that they still receive a database connector error 9 message.

The workaround for this is to navigate to your ODBC Driver Setup for SOTAMAS90 and under OPTIONS set the NULL Date option box so that it is checked (by default it should be blank).

Now apply those changes and re-try your Crystal Report and you’ll now be able to pull data from the bad records. Sort the date field by ascending or descending and the bad value almost always flows to the top. Identify the bad record and use Sage 100 Data File Display and Maintenance to correct it.

 

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: sage 100

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and 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 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • Sage Summit San Diego 2019 Wrap-Up February 15, 2019
  • Is Sage 100 cloud hosting right for you? February 12, 2019
  • What is Sage 100cloud Multi-Bin Management, and do I need it? February 5, 2019
  • Sage 100 Migration Promotions – 2019 January 31, 2019
  • Sage 100 eFiling Deadlines for 2018 January 21, 2019
  • Sage Summit 2019 – Agenda for Sage 100 Customers Released January 20, 2019
  • How To Resolve: Sage 100cloud Subscription Expiration Notice In Error January 18, 2019
  • How To Setup Sage 100 or Sage100cloud for Integrated Credit Card or ACH Processing January 17, 2019
  • Sage Summit 2019 – San Diego – Sponsor List Released January 16, 2019
  • Sage 100 and Sage 100cloud Supported Versions – January 2019 January 16, 2019

Contact Us

Schulz Consulting
160 Oak Street
Glastonbury, CT 06033
Phone: 833.724.3100
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide. We are a local affiliate of DSD Business Systems.

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

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.