Sage 100

Anyone seen this error before during printing. MAS200 v4.40 Says ""unable to print. failed to retrieve data from database - database vendor code 12

Something similar is on the KB and I think it was like a bad date field maybe?

That is an code 9 and This is a code 12. It is happening when printing reports throughout system. Going to try to rename sy_workstation.

there is something about database vendor code 12 on KB, maybe related to special characters - resolution ID 527016 - maybe try reconverting data?

Do you have more than one data source on the report?

Printing works fine on the server as mas200 and in mas90 mode on workstations. Baffling.

So the answer to the question what causes an Database vendor code 12..... If Someone enables the C/S ODBC and enables it for all user and doesn't set it up correctly the users receive the Vendor code 12 and will be unable to print. Unchecking the enable for all users will resolve the error.

Going to have a chat with the folks at Website Pipeline to see what excuse they have..... Expecting an oh we didn't know response.

Well it was an oops and a sorry.