locked
Installation Failure for DB2 OLE DB Provider V3 RRS feed

  • Question

  • Hello All,

    I'm trying to install V3 of the DB2 OLEDB provider on a 64bit Windows Server2008 machine. SQL Server 2008 Standard is installed, running, and functional. However, when I run setup.exe, it fails and tells me that "a supported version of SQL Server 2005 or greater is not installed." I checked the log that it generates, and the setup process correctly indentifies my SQL version (10.2.4000.0) but finally exits with "Prehook Init function failed and returned the following error message: Setup cannot continue because a supported version of SQL Server 2005 or greater is not installed. Supported versions include Enterprise, Developer, or Enterprise Evaluation"

    From the product download page, it looked like 2008 Standard was supported. Is this not correct? I'll paste the log file below. Thanks to anyone that can help, it is very appreciated :) Thank you!

    === Logging started at: 12:03:29 PM Tuesday, June 28, 2011 Build: 8.0.4294.0 Calling process: C:\Temp\MS OLEDB DB2\Setup.exe === The current user is USPHC\mb54803. Computer name: GTF075F07 OS Version: 6.0 Build: 6002 Service Pack: 2.0 Suite: 274 Product Type: 3
    [12:03:29 PM Info] Command Line: C:\Temp\MS OLEDB DB2\Setup.exe
    [12:03:29 PM Info] Language: 1033
    [12:03:31 PM Info] Raw module path: C:\Temp\MS OLEDB DB2\Setup.exe
    [12:03:31 PM Info] Universal module path: C:\Temp\MS OLEDB DB2\Setup.exe
    [12:03:31 PM Info] Current version of msi.dll is: 4.5 build: 6002 platform: 2
    [12:03:31 PM Info] Raw module path: C:\Temp\MS OLEDB DB2\Setup.exe
    [12:03:31 PM Info] Universal module path: C:\Temp\MS OLEDB DB2\Setup.exe
    [12:03:32 PM Info] Raw module path: C:\Temp\MS OLEDB DB2\Setup.exe
    [12:03:32 PM Info] Universal module path: C:\Temp\MS OLEDB DB2\Setup.exe === Logging stopped: 12:03:33 PM Tuesday, June 28, 2011 === === Logging started at: 12:03:34 PM Tuesday, June 28, 2011 Build: 8.0.4294.0 Calling process: C:\Users\mb54803\AppData\Local\Temp\EBZ21971.tmp\Setup.exe === The current user is USPHC\mb54803. Computer name: GTF075F07 OS Version: 6.0 Build: 6002 Service Pack: 2.0 Suite: 274 Product Type: 3
    [12:03:34 PM Info] Command Line: C:\Temp\MS OLEDB DB2\Setup.exe /Relaunch /RunningFromTemp /SetupXML C:\Users\mb54803\AppData\Local\Temp\EBZ21971.tmp\HISDB2_x64.xml
    [12:03:34 PM Info] Language: 1033
    [12:03:34 PM Info]
    [12:03:34 PM Info] Running prehook init function
    [12:03:34 PM Info] Entering PreInitHook
    [12:03:34 PM Info] Detecting Sql Server (32bit)
    [12:03:34 PM Info] Enumerating Sql Server instances from Software\Microsoft\Microsoft SQL Server\Instance Names\SQL
    [12:03:34 PM Info] Done enumerating Sql Server instances, original hr = 0X80070002
    [12:03:34 PM Info] Done enumerating Sql Server instances, hr = 00000000
    [12:03:34 PM Info] Enumerating Sql Server instances from Software\Microsoft\Microsoft SQL Server\Instance Names\OLAP
    [12:03:34 PM Info] Done enumerating Sql Server instances, original hr = 0X80070002
    [12:03:34 PM Info] Done enumerating Sql Server instances, hr = 00000000
    [12:03:34 PM Info] Enumerating Sql Server instances from Software\Microsoft\Microsoft SQL Server\Instance Names\RS
    [12:03:34 PM Info] Done enumerating Sql Server instances, original hr = 0X80070002
    [12:03:34 PM Info] Done enumerating Sql Server instances, hr = 00000000
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\100\BIDS\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\100\DTS\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup
    [12:03:34 PM Info] EULA
    [12:03:34 PM Info] Done detecting Sql Server, hr = 00000000
    [12:03:34 PM Info] Detecting Sql Server (64bit)
    [12:03:34 PM Info] Enumerating Sql Server instances from Software\Microsoft\Microsoft SQL Server\Instance Names\SQL
    [12:03:34 PM Info] Checking SQL version and edition for: Software\Microsoft\Microsoft SQL Server\MSSQL10.GTFSPPROD\Setup
    [12:03:34 PM Info] Got Version 10.2.4000.0
    [12:03:34 PM Info] Got edition Standard Edition
    [12:03:34 PM Info] Found SQL Server Standard Edition.
    [12:03:34 PM Info] Not the correct edition.
    [12:03:34 PM Info] Done enumerating Sql Server instances, original hr = 0X80070103
    [12:03:34 PM Info] Done enumerating Sql Server instances, hr = 00000000
    [12:03:34 PM Info] Enumerating Sql Server instances from Software\Microsoft\Microsoft SQL Server\Instance Names\OLAP
    [12:03:34 PM Info] Checking SQL version and edition for: Software\Microsoft\Microsoft SQL Server\MSAS10.GTFSPPROD\Setup
    [12:03:34 PM Info] Got Version 10.2.4000.0
    [12:03:34 PM Info] Got edition Standard Edition
    [12:03:34 PM Info] Found SQL Server Standard Edition.
    [12:03:34 PM Info] Not the correct edition.
    [12:03:34 PM Info] Done enumerating Sql Server instances, original hr = 0X80070103
    [12:03:34 PM Info] Done enumerating Sql Server instances, hr = 00000000
    [12:03:34 PM Info] Enumerating Sql Server instances from Software\Microsoft\Microsoft SQL Server\Instance Names\RS
    [12:03:34 PM Info] Done enumerating Sql Server instances, original hr = 0X80070002
    [12:03:34 PM Info] Done enumerating Sql Server instances, hr = 00000000
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\100\BIDS\Setup
    [12:03:34 PM Info] Got Version 10.2.4000.0
    [12:03:34 PM Info] Got edition Standard Edition
    [12:03:34 PM Info] Found SQL Server Standard Edition.
    [12:03:34 PM Info] Not the correct edition.
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\100\DTS\Setup
    [12:03:34 PM Info] Got Version 10.2.4000.0
    [12:03:34 PM Info] Got edition Standard Edition
    [12:03:34 PM Info] Found SQL Server Standard Edition.
    [12:03:34 PM Info] Not the correct edition.
    [12:03:34 PM Info] Checking SQL version and edition for: SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup
    [12:03:34 PM Info] Got Version 10.2.4000.0
    [12:03:34 PM Info] Got edition Standard Edition
    [12:03:34 PM Info] Found SQL Server Standard Edition.
    [12:03:34 PM Info] Not the correct edition.
    [12:03:34 PM Info] EULA
    [12:03:34 PM Info] Done detecting Sql Server, hr = 00000000
    [12:03:34 PM Info] Leaving PreInitHook (hr = 0X00000001)
    [12:03:34 PM Info] Prehook Init function returned: 1.
    [12:03:34 PM Info] Prehook Init function failed and returned the following error message: Setup cannot continue because a supported version of SQL Server 2005 or greater is not installed. Supported versions include Enterprise, Developer, or Enterprise Evaluation. === Logging stopped: 12:03:39 PM Tuesday, June 28, 2011 ===

    Tuesday, June 28, 2011 4:13 PM

Answers

All replies

  • Hello Mitch,

    This isn't any MS SQL Server (Data Access) problem; you should post your question to a IBM DB2 related forum.


    Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog Xing
    Wednesday, June 29, 2011 4:53 PM
  • The MS OLEDB DB2 provider is made by Microsoft and the issue is happening when Microsoft's installer tries to install a Microsoft product on a Microsoft operating system and fails to recognize a valid Microsoft SQL Server product. It shouldn't have anything to do with IBM/DB2, as the error is not happening in a connection related scenario. Perhaps I don't understand the product correctly?
    Wednesday, June 29, 2011 5:02 PM
  • Hello,

    It seems that the MS OLEDB DB2 provider is supported on Entreprise or DataCenter editions http://blogs.msdn.com/b/sjackson/archive/2010/06/11/microsoft-ole-db-provider-for-db2-v3-0-is-available.aspx

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16978

    For the last link, look at the part Microsoft® OLEDB Provider for DB2 , you will find :

    "The Microsoft OLE DB Provider for DB2 Version 3.0 offers a set of technologies and tools for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2008 R2 Enterprise Edition and Developer Edition"

    It is written only for Entreprise and Developer Editions not standard edition

    According to me, this provider (V 2.0 or 3.0 ) is not supported with SQ Server Standard Edition, it is why you have the message "Not the correct edition"

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
    Sunday, July 3, 2011 5:30 PM
  • Thanks, Papy; I appreciate you pointing me in the right direction.
    Tuesday, July 5, 2011 2:50 PM