FIX: Cannot Add Microsoft Solution for Internet Business Address Book If Profile Schema Database Is Separated from Data Sources Table (318179)


The information in this article applies to:

  • Microsoft Solution Offering - Microsoft Solution for Internet Business
  • Microsoft Commerce Server 4.0
  • Microsoft Commerce Server 2000
This article was previously published under Q318179

SYMPTOMS

When you add an address in the Microsoft Solution for Internet Business (MSIB) 1.0 Address Book, the Address Book may not display the address if the Profile Definition and the Profile Data Sources are in separate databases. If you set Microsoft Solution for Internet Business in development mode, you may receive the following error message:
Microsoft VBScript runtime (0x800A01A8) Object required: 'rsAddresses' /PageInclude/NewAddressBody.asp, line 1125

CAUSE

This problem occurs because Microsoft Solution for Internet Business 1.0 uses the wrong method to connect to the database. Instead of using the CommerceProvider, Microsoft Solution for Internet Business uses the DbHelper method of generating the recordset.

RESOLUTION

The following fix uses the CommerceProvider ActiveX Data Objects (ADO) Recordset object to properly retrieve the recordset. CommerceProvider provides a background link to the run-time store location where the UserObject and the Address tables reside.

This fix is related to the Content Connector requirements in which the Campaign, the Profile Definitions, and the Content Connector resources must reside in the same database. For more information about this restriction, see the Microsoft Solution for Internet Business Operations Guide.

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel. 
   Date         Time   Size    File name     
   --------------------------------------------
   20-May-2002  15:37  45,918  NewAddressBook.asp
   20-May-2002  15:37  23,726  AddressBookBody.asp
   20-May-2002  15:37  25,018  AspAddressLib.asp
   20-May-2002  15:37   8,110  Global.asa
NOTE: Before you install the hotfix, back up the original .asp files. To install this hotfix, make sure that you copy the Global.asa file to the root of your Web site, copy the NewAddressBook.asp and the AddressBookBody.asp files to the Pageinclude folder, and then copy the AspAddressLib.asp file to the Include folder. You may have to run the iisreset command at a command prompt after you copy the files.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

When a user who is logged on submits a new address to the Address Book, Microsoft Solution for Internet Business 1.0 compares the address name of the existing recordset with the newly submitted address name to make sure that the new address is unique. The recordset creation fails because the s_BizDataStoreConnectionString strings that are passed to the DbHelper are incorrect, which results in an empty recordset.

The UserObject and the Address tables that are in the Data Sources may grow very large and may require frequent writing. Because Microsoft Solution for Internet Business cannot separate Profile Definitions from the Data Sources, a scalability issue occurs in a production environment.

The following files are affected:
  • \Pageinclude\NewAddressBook.asp
  • \Pageinclude\AddressBookBody.asp
  • \Include\AspAddressLib.asp
  • Global.asa
Modification Type:MinorLast Reviewed:10/19/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix KB318179
©2004 Microsoft Corporation. All rights reserved.