DB2OLEDB Failed to install on SQL Server 2005 Developer Edition

I have SQL Server 2005 Developer Edition installed on XP Pro sp2 and have not been able to get OLE DB Provider for DB2 Version 1.0 with Service Pack 1 to install. After getting a notice that the install has failed, I get these log files:

=== Logging started at: 2:12:35 PM Monday, August 20, 2007 Build: 7.0.3038.0 Calling process: H:\SQL2005\DB2OLEDB7\Setup.exe === The current user is NORTHGRUM\dinsest. Computer name: DICA2ESITE13005 OS Version: 5.1 Build: 2600 Service Pack: 2.0 Suite: 256 Product Type: 1
[2:12:35 PM Info] Command Line: H:\SQL2005\DB2OLEDB7\Setup.exe
[2:12:35 PM Info] Language: 1033
[2:12:59 PM Info] Raw module path: H:\SQL2005\DB2OLEDB7\Setup.exe
[2:12:59 PM Info] Universal module path: H:\SQL2005\DB2OLEDB7\Setup.exe
[2:12:59 PM Info] Current version of msi.dll is: 3.1 build: 4000 platform: 2
[2:12:59 PM Info] Raw module path: H:\SQL2005\DB2OLEDB7\Setup.exe
[2:12:59 PM Info] Universal module path: H:\SQL2005\DB2OLEDB7\Setup.exe === Logging stopped: 2:12:59 PM Monday, August 20, 2007 === === Logging started at: 2:13:00 PM Monday, August 20, 2007 Build: 7.0.3038.0 Calling process: C:\DOCUME~1\dinsest\LOCALS~1\Temp\EBZ34671.tmp\Setup.exe === The current user is NORTHGRUM\dinsest. Computer name: DICA2ESITE13005 OS Version: 5.1 Build: 2600 Service Pack: 2.0 Suite: 256 Product Type: 1
[2:13:00 PM Info] Command Line: H:\SQL2005\DB2OLEDB7\Setup.exe /Relaunch /RunningFromTemp /SetupXML C:\DOCUME~1\dinsest\LOCALS~1\Temp\EBZ34671.tmp\HISDB2_x86.xml
[2:13:00 PM Info] Language: 1033
[2:13:00 PM Info]

[2:13:00 PM Info] Running prehook init function
[2:13:00 PM Info] Entering PreInitHook
[2:13:00 PM Info] Detecting Sql Server 2005 (32bit)
[2:13:00 PM Info] Enumerating Sql Server 2005 instances from Software\Microsoft\Microsoft SQL Server\Instance Names\SQL
[2:13:00 PM Info] Checking SQL version and edition for: Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup
[2:13:00 PM Info] Got Version 9.2.3042.00
[2:13:00 PM Info] Got edition Developer Edition
[2:13:00 PM Info] Done enumerating Sql Server 2005 instances, original hr = 00000000
[2:13:00 PM Info] Done enumerating Sql Server 2005 instances, hr = 00000000
[2:13:00 PM Info] Done detecting Sql Server 2005, hr = 00000000
[2:13:00 PM Info] Detecting existing integration server installations
[2:13:00 PM Info] Integration server is not installed
[2:13:00 PM Info] Done detecting existing integration server installations, hr = 00000000
[2:13:00 PM Info] Leaving PreInitHook (hr = 00000000)
[2:13:00 PM Info] Prehook Init function returned: 0.
[2:13:00 PM Info] Prehook Init function returned the following mode: 0
[2:13:01 PM Info] Product code: {722CAF00-DE6E-4438-82DE-E664B8B6222B}
[2:13:01 PM Info] Product name: Microsoft OLE DB Provider for DB2
[2:13:01 PM Info] Product PIDSKU: BI6-00082
[2:13:01 PM Info] Product Code (MPC): 91197
[2:13:01 PM Info] OEMID:
[2:13:01 PM Info] Product is not already installed.
[2:13:01 PM Info] Successfully opened Msi package: H:\SQL2005\DB2OLEDB7\Msi\x86\HISDB2.msi
[2:13:01 PM Info] Raw module path: C:\DOCUME~1\dinsest\LOCALS~1\Temp\EBZ34671.tmp\Setup.exe
[2:13:01 PM Info] Universal module path: C:\DOCUME~1\dinsest\LOCALS~1\Temp\EBZ34671.tmp\Setup.exe
[2:13:10 PM Info] Initializing Component Updater ...
[2:13:10 PM Info] Initialized Component Updater
[2:13:10 PM Info] No updates were found on the SUS server to download.
[2:13:14 PM Info] Required platform components:
[2:13:20 PM Info] Initializing Component Updater ...
[2:13:20 PM Info] Initialized Component Updater
[2:13:20 PM Info] No updates were found on the SUS server to download.
[2:13:20 PM Info] Required platform components: (none)
[2:13:20 PM Info] MSI command line: ADDLOCAL=REQUIRED_FEATURE,OLE_DB_PROVIDER_FOR_DB2 INSTALLDIR="C:\Program Files\Microsoft OLE DB Provider for DB2\" PIDKEY="R2D433DHG9DQ79WW3DXQ929DY" USERNAME="Northrop Grumman Corporation" COMPANYNAME="NGGN" FILESINUSEERROR=""
[2:13:20 PM Info] MSI command line is ADDLOCAL=REQUIRED_FEATURE,OLE_DB_PROVIDER_FOR_DB2 INSTALLDIR="C:\Program Files\Microsoft OLE DB Provider for DB2\" PIDKEY="R2D433DHG9DQ79WW3DXQ929DY" USERNAME="Northrop Grumman Corporation" COMPANYNAME="NGGN" FILESINUSEERROR=""
[2:13:20 PM Info] Detailed Log information for product H:\SQL2005\DB2OLEDB7\Msi\x86\HISDB2.msi is available at DetailedLog
[2:13:20 PM Info] MSI installation returned 2 - The system cannot find the file specified.
[2:13:20 PM Error] Error 0 occurred during MSI installation.
[2:13:20 PM Error]
[2:13:20 PM Error] === Logging stopped: 2:13:25 PM Monday, August 20, 2007 ===

Detailed Log

=== Verbose logging started: 8/20/200714:13:20Build type: SHIP UNICODE 3.01.4000.2435Calling process: C:\DOCUME~1\dinsest\LOCALS~1\Temp\EBZ34671.tmp\Setup.exe ===

MSI (c) (E4C) [14:13:20:343]: Resetting cached policy values

MSI (c) (E4C) [14:13:20:343]: Machine policy value 'Debug' is 0

MSI (c) (E4C) [14:13:20:343]: ******* RunEngine:

******* Product: H:\SQL2005\DB2OLEDB7\Msi\x86\HISDB2.msi

******* Action:

******* CommandLine: **********

MSI (c) (E4C) [14:13:20:343]: Client-side and UI is none or basic: Running entire install on the server.

MSI (c) (E4C) [14:13:20:343]: Grabbed execution mutex.

MSI (c) (E4C) [14:13:20:359]: Cloaking enabled.

MSI (c) (E4C) [14:13:20:359]: Attempting to enable all disabled priveleges before calling Install on Server

MSI (c) (E4C) [14:13:20:359]: Incrementing counter to disable shutdown. Counter after increment: 0

MSI (s) (B88) [14:13:20:374]: Grabbed execution mutex.

MSI (s) (B8:90) [14:13:20:374]: Resetting cached policy values

MSI (s) (B8:90) [14:13:20:374]: Machine policy value 'Debug' is 0

MSI (s) (B8:90) [14:13:20:374]: ******* RunEngine:

******* Product: H:\SQL2005\DB2OLEDB7\Msi\x86\HISDB2.msi

******* Action:

******* CommandLine: **********

MSI (s) (B8:90) [14:13:20:374]: Machine policy value 'DisableUserInstalls' is 0

MSI (s) (B8:90) [14:13:20:406]: MainEngineThread is returning 2

MSI (c) (E4C) [14:13:20:421]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.Counter after decrement: -1

MSI (c) (E4C) [14:13:20:421]: MainEngineThread is returning 2

=== Verbose logging stopped: 8/20/200714:13:20 ===

Does anyone have an idea as to why the installation is failing?

TIA,

Steve

P.S. Those aren't really smileys, they're actually semicolon Ds but I can't seem to get rid of the cartoon translation, even after checking the "This post contains a code sample" checkbox.

Trial and error has provided my answer to this problem. It seems that not all executables will perform as expected when run from a USB attached drive. Copying them to the C: drive and then executing them was the only way this worked.

Hope this will help someone else. I didn't know this would be a problem.

Steve

sql