How to prepare the BlackBerry Enterprise Server for Microsoft Exchange to support DST changes in 2008

---

Doc ID : KB15058
Last Modified : 2008-06-12
Document Type : How To

Print this page

Environment

• BlackBerry® Enterprise Server software version 4.0 Service Pack 7 (4.0.7) for Microsoft® Exchange
• BlackBerry smartphones
• SDR159527
• SDR138787

Procedure

The Daylight Saving Time (DST) will change for the following time zones.

Note: Guyana's time zone of Buenos_Aires has been renamed Georgetown.

*Note: To monitor future updates on the Microsoft CDO patch updates, search for article 933360 at the Microsoft Support web site.

Complete the following to support the DST 2008 changes to the BlackBerry Enterprise Server for Microsoft Exchange.

BlackBerry Enterprise Server for Microsoft Exchange

1. To support the time zone changes, the Windows® operating system needs to have a time zone update applied. If the Windows time zone update is not applied, the TimeZoneUpdate20080207.zip script will not function as intended. For more information, search for article 942763 on the Microsoft Support web site.
2. The new time zone information provided by CDO.dll needs to be applied to the BlackBerry Enterprise Server. This information can be obtained by searching for article 943068 on the Microsoft Support web site.
3. Download and run the attached script, TimeZoneUpdate20080207.zip, on the BlackBerry Enterprise Server. For instructions, see the Additional Info section in this article.

   Note: A known issue exists (SDR138787) as a result of applying the CDO.dll change. A duplicate appointment may occur if meetings are updated after they have been accepted.

BlackBerry Enterprise Server Registry modifications to add time zone information

Warning: The following procedure involves modifying the computer registry. This can cause substantial damage to the Windows operating system. Document and back up the registry entries prior to implementing any changes.

1. Download the file Update_for_CDO_6.5.7653.21-6.5.7974.0.reg to the BlackBerry Enterprise Server.
2. Double-click the file to apply the changes.
3. Restart the BlackBerry Enterprise Server.

   Important: Restarting the BlackBerry Enterprise Server will delay email message delivery to BlackBerry smartphones. For more information, see KB04789.

BlackBerry smartphones

Warning: If you apply the following DST 2008 time zone change to a BlackBerry smartphone that is already patched, or activate a new BlackBerry smartphone with the correct DST values against a BlackBerry Enterprise Server that does not have the newest time zone table, the BlackBerry Enterprise Server will override the values on the BlackBerry smartphone.

The 4.1MR4+_Patch.zip and 4.2+_Patch.zip patches resolve the DST 2008 issue if you are running one of the following BlackBerry® Device Software versions:

• BlackBerry Device Software 4.1.0.344 through 4.1.0.365
• BlackBerry Device Software 4.1.0.373
• BlackBerry Device Software 4.1.0.375 through 4.1.0.385

For BlackBerry smartphones running BlackBerry Device Software 4.1.0, download the 4.1MR4+_Patch.zip. There are two ways to download the patch:

• For administrators, or for installing the patch using the Application Loader in BlackBerry® Desktop Manager, to download the 4.1MR4+_Patch.zip, click here. For instructions on installing the patch using the Application Loader, see KB15172.
• To download the patch wirelessly from a BlackBerry smartphone, click here.

For BlackBerry smartphones running BlackBerry Device Software 4.2 or later, download the 4.2+_Patch.zip. There are two ways to download the patch:

• For administrators or for installing the patch using the Application Loader in BlackBerry Desktop Manager, to download the 4.2+_Patch.zip, click here. For instructions on installing the patch using the Application Loader, see KB15172.
• To download the patch wirelessly from a BlackBerry smartphone, click here.

The patch can also be deployed to BlackBerry smartphones from the BlackBerry Enterprise Server. See KB03748 for detailed instructions on preparing a software configuration for wireless deployment.

Additional Info

Running the Script against the BlackBerry Configuration Database

When running the LoadSyncDeviceConfig.sql script (located in the attached TimeZoneUpdate20080207.zip file), you can customize how the LoadSyncDeviceConfig.sql script is executed by using various switches. The following tables list the required and optional switches to run the LoadSyncDeviceConfig.sql script.

Required Switches

Optional Switches

Running the TimeZoneUpdate20080207.zip Update

Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.

1. Download the attached TimeZoneUpdate20080207.zip file and extract it to the BlackBerry Enterprise Server.

   Important: Do not modify the file structure of TimeZoneUpdate20080207.zip.

2. If you are using Microsoft SQL Server or MSDE, go to the TimeZoneUpdate20080207\SQLServer folder and open the LoadSyncDeviceConfig.sql file using a text editor, such as Notepad.
3. Modify the following line to specify the name of the BlackBerry Configuration Database:

   USE "_DATABASENAME_"

   For example, USE BESMGMT

4. Save the changes and close the file.
5. On the BlackBerry Enterprise Server, open a command prompt.
6. Navigate to the root folder where the LoadSyncDeviceConfig.sql script is contained.
7. Type the appropriate command for your environment. The following is a example, using the default BlackBerry Configuration Database name and a remote Microsoft SQL Server:

   BBDBUpdate.exe –db BESMgmt -n SQL.domain.com -input .\SQLServer\LoadSyncDeviceConfig.sql

   The full command syntax is as follows:

   BBDBUpdate.exe –db <Database Name> -dbms <SQL> -n <SQL Server Name> -dbauth –dbuser <User Name> -dbpass <Password> -input <.\SQLServer\LoadSyncDeviceConfig.sql>

   Where

   • <Database Name> is the name of the BlackBerry Configuration Database
   • <SQL> is selected if you are running a Microsoft SQL Server in your environment
   • <SQL Server Name> is the Microsoft SQL Server name
   • <User Name> is the appropriate user name for Microsoft SQL Server authentication
   • <Password> is the appropriate password for Microsoft SQL Server authentication
   • <.\SQLServer\LoadSyncDeviceConfig.sql> is the Microsoft SQL Server Location for the LoadSyncDeviceConfig.sql script when using a Microsoft SQL Server

Attachments

• Update_for_CDO_6.5.7653.21-6.5.7974.0.reg
• TimeZoneUpdate20080207.zip