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.
