Microsoft KB Archive/318179

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

Article ID: 318179

Article Last Modified on 11/15/2007

-

APPLIES TO


 * Microsoft Solution for Internet Business 2.5
 * Microsoft Commerce Server 4.0 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



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. However, this hotfix is intended to correct only the problem that this article describes. Apply this hotfix only to systems that are experiencing this specific problem.

To resolve this problem, submit a request to Microsoft Online Customer Services to obtain the hotfix. To submit an online request to obtain the hotfix, visit the following Microsoft Web site:

http://go.microsoft.com/?linkid=6294451

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. To create a separate service request, visit the following Microsoft Web site:

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

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

Additional query words: cs2k retail

Keywords: kbhotfixserver kbqfe kbbug kbfix KB318179

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.