Advertiser Report Add-In Causes Ad Manager Error Message (256242)

SYMPTOMS

The Advertiser Report is a downloadable add-on to the release of Ad Server from Microsoft Site Server 3.0, Commerce Edition. This self-extracting program provides an additional feature that allows you to create login accounts so that your advertisers can view performance reports in real time. After you install the Advertiser Report and you click either Customer in Ad Manager (http://localhost/admanager/customer_list.asp) or Submit in the Advertiser Performance Report (http://localhost/adreport/), the following error message may occur:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The requested properties can not be supported by this ODBC Driver.

CAUSE

Advertiser Report Setup creates a table named as_login in the Ad Server database. The script that creates this table fails if the Ad Server table (as_customer) does not have customer_id set as the primary key. If the as_customer table does not have customer_id set as the primary key, attempts to manually run this script (\wwwroot\adreport\config\schema.sql) generate the following error message:

There are no primary or candidate keys in the referenced table 'as_customer'
that match the referencing column list in the foreign key 'FK_login_customer'.

WORKAROUND

The best workaround at this point is to disable the Advertiser Report add-in to return Ad Manager functionality. To do this, locate the customer_funcs.asp file in the AdManager\Include directory and replace it with the Customer_funcs.asp.bak file from the same directory.