ShowCase STRATEGY ODBC 3.01.060 Patch

IBM DB2 OLAP Server for AS/400 1.1
Fixpack 12:

Warehouse Builder ODBC patch

Please read and print these instructions before installing the patch!

These patches are language specific. Please download the patch for your language only.

Patch Applicable Version

English (287 KB) STRATEGY 3.0 (12/08/99 and later)

French (246 KB) STRATEGY 3.0 (03/06/00)

German (246 KB) STRATEGY 3.0 (03/06/00)

Spanish (195 KB) STRATEGY 3.0 (03/24/00)

Patch	Applicable Version
English (287 KB)	STRATEGY 3.0 (12/08/99 and later)
French (246 KB)	STRATEGY 3.0 (03/06/00)
German (246 KB)	STRATEGY 3.0 (03/06/00)
Spanish (195 KB)	STRATEGY 3.0 (03/24/00)

Applicable Versions
This patch applies to ShowCase ODBC 3.01.00 and later. After the patch is applied, ShowCase ODBC will be upgraded to 3.01.060.

Summary of problems fixed

Resolved a problem where ODBC clients would hang on an initial connection intermittently.(F6054)

In addition, this patch incorporates the 3.01.050 patch to resolve:

No new failures addressed in this patch.

In addition, this patch incorporates the 3.01.040 patch to resolve:

The ShowCase ODBC driver will now protect your original WHERE clause search condition with parenthesis before adding any row conditions specified in your ShowCase row security entries for the tables referenced by the query. (F4717)

In addition, this patch incorporates the ODBC 3.01.020 patch to resolve the following:

ShowCase ODBC was not returning the new password entered in our TCP/IP support for expired passwords, causing Report Writer to attempt to use the old password in subsequent connections. This fix now returns the required information. (F4105)
Changes in the ShowCase ODBC driver in 3.01 respin did not allow DataViews defined in Query Designer to be created on the AS/400. This fix resolves the problem. (F4148)

Patch Installation Instructions
The first time you apply a patch to a ShowCase feature, you must download the patchw32.dll file. This file contains the core functionality for the patch program used by the PTF. We recommend that the patchw32.dll be copied to the Windows System directory and be retained there for future use.

Download the Patch (287 KB)
Copy the PTF to the drive containing SCODBC32.DLL (NOTE: Do not copy this file to your Backup folder)
Double-click on O301062.exe.

A Welcome dialog box appears, and the software searches for the SCODBC32.DLL to update. Note: The patch can only search the drive to which it is copied.

The patch program runs and automatically modifies, adds, renames, or deletes files as necessary to complete the patch.

The original file is saved in the BACKUP directory, which is automatically created on the drive from which the patch is run.

Undoing the Patch
If you want or need to get back to the original files (before the patch was applied), you will find them in the BACKUP directory, which is located on the drive that the patch is run from. The BACKUP directory contains a file called unpatch.bak. This file is a script file containing the commands necessary to automatically restore the original files. To restore the original files (from any operating system environment):

Locate the unpatch.bak
Rename the unpatch.bak to unpatch.bat
At an MS-DOS prompt, type the path to unpatch.bat (E.g., C:\ProgramFiles\STRATEGY\Desktop\Backup\unpatch.bat) and press Enter.

On the desktop, click Start > Run, and browse for the patch to unpatch.bat. Click OK.

Your application is automatically restored to its pre-patch configuration.

If you apply multiple PTFs over time, the BACKUP directory will contain multiple, consecutively numbered copies (for example, unpatch.bak, unpatch.001, unpatch.002) of unpatch files and the related original files from each backup. You may wish to periodically clean the BACKUP directory to recover disk space. To keep the most recent backup information, keep the unpatch.bak (or unpatch.bat if you already renamed it) file and the files listed in its text.

Back to Patch Description