Sage 100

 View Only
  • 1.  MAS200 v4.5.07 SQL database - Customer is receivin

    Posted 09-23-2013 12:39
    MAS200 v4.5.07 SQL database - Customer is receiving the ""Failed to Open Connection. Details: [Database Vendor Code: 17]"" message. Knowledgebase links to only one reference that I can see and it refers to turning on some services on the SQL box. Confirmed that all of those are turned on and active, per the article. Still receiving the same message. Any other ideas or has anyone else resolved this issue with another fix? Checked with the client and they haven't made any changes to the SQL box. I'm sticking with that until I have something else to look for.


  • 2.  RE: MAS200 v4.5.07 SQL database - Customer is receivin

    Posted 09-23-2013 12:42
    This has nothing to do with SQL, but I have gotten a message like that when the queried record set contains a date record with a bad date in it. Often i have to go through DFDM to find the bad record. Just another possibllity


  • 3.  RE: MAS200 v4.5.07 SQL database - Customer is receivin

    Posted 09-23-2013 13:03
    I've been getting those #$(*&^#$$ errors re bad dates a LOT in the last two years.


  • 4.  RE: MAS200 v4.5.07 SQL database - Customer is receivin

    Posted 09-23-2013 13:49
    Is this a report? If so, is it only one or is it all reports? Could be a bad data source (ODBC or OLEDB).


  • 5.  RE: MAS200 v4.5.07 SQL database - Customer is receivin

    Posted 09-24-2013 02:14
    It's actually showing on the SO Invoice Printing. I've instructed them to do a little narrowing to try and find a corrupt record. Waiting to hear back some results. Thanks for all the feedback so far.