When I attempt to run one of my Reporting4Act! reports, I receive the message "Microsoft OLE DB Provider for SQL Server: Operand type clash."

In order to retrieve information from Act! databases, Reporting4Act! uses a tool called the Act! OLE/DB Data Provider. This error message indicates that there is some corruption in the data views making up this tool. To resolve this problem, these data views can be recreated, using the Act! Diag tool. The instructions for this are available in the Recreating Act! Database Views in Actdiag topic.

© Keystroke.ca, 1996-2021 • Updated: 02/09/21
Comment or report problem with topic