Stonefield Query Home > Stonefield Help Desk > Knowledgebase

Search help:

A message reading Microsoft OLE DB Provider for SQL Server : The multi-part identifier -name- could not be bound appears when running a report.


Applies to:

  • Stonefield Query for ACT!

Problem: A message reading "Microsoft OLE DB Provider for SQL Server : The multi-part identifier -name- could not be bound" appears when running a report.

Explanation: This message can appear for reports in the following specific circumstances.

  • The report uses the ACT! 2005-2009 data provider.
  • The report is being run with ACT! 2010 or later.
  • The fields on the report are all from one of the opportunity tables, such as Contact Opportunity or Company Opportunity.
  • The report filters on at least two opportunity fields, including at least one calculated field.
  • The report does not include the Opportunity ID field.

Solution: The error message can be prevented by avoiding any of the conditions in the above list. The simplest solution is to add the Opportunity ID field to the report. If you do not wish to display this field on the report, you can turn off the Display this field checkbox in its field properties screen.

Was this article helpful? yes / no
Related articles A message reading "Property CursorSchema has invalid value." appears when running a Stonefield Query for ACT! report.
A message reading "ACT! OleDB Provider for Reporting 2.0 : Undefined column name -name-" appears when running a report.
Adding Fields to Advanced Layout Reports
The "does not contain" operator is not returning all matching records in Stonefield Query for ACT!.
Improving the Performance of Calculated Fields and Formulas
Article details
Article ID: 21
Category: Error Messages
Rating (Votes): Article rated 3.0/5.0 (56)

« Go back