Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

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

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

  • Beware Fake Sage Support Sites
  • When Is Sage 100 Payroll 2.24 for 2023 Due?
  • Which Crystal Reports Versions Are Compatible With Sage 100 (As of October 2023)?
  • Windows Server 2012 R2 No Longer Supported with Sage 100
  • How can I see the tax tables being used for Payroll taxes?
  • Sage TLS 1.2 Change Deferred For Some Through March 2024
  • Sage 100 Updates for 2023: The Year-End Edition You Can’t Afford to Miss
  • Summit Hosting Rebrands as Summit
  • Does Sage have plans to stop supporting TLS 1.0 & 1.1 for Sage 100?
  • Payroll Requirements for Year-End 2023

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.