Linked server with DB2 required files are missing.

  • How can I install Microsoft Visual C++ 2010 x86 Runtime on a SQL Server 2008. This server do no have anything installed except SQL Server. I want to make a linked server connecting with DB2 database so when I tried to installed DB2OLEDBV4_x64 (Microsoft OLEDB Provider for DB2), it failed with error:

    Microsoft OLE DB Provider for DB2 version 4.0 requires Microsoft Visual Studio 2010 C++ Runtime libraries.

    see attachment. when I tried to search and installed I found vcredist_x64 file. After installing this, same error is still appearing. Kindly let me know the url from where I can find the desired file that installed C++ runtime?

    Shamshad

  • You downloaded the 64-bit version

    You might want the 32-bit version (X86)

  • OS and SQL Server both are x64. I tried both installations but they are all installing Redistriubutable(s). The required one is Microsoft Visual C++ 2010 Runtime

    Shamshad

  • I solved the c++ runtime requirement by installing first VS2010Express1.iso (installed only VC++) then installed Service Pack-1 of VS2010 from [VS10sp1-KB983509.exe] or [VS2010SP1dvd1.iso] visual studio 2010 SP1 full standalone installation.

    This fulfilled the requirement of Microsoft Visual C++ 2010 runtime requirement to be installed on machine where you want to make DB2 as linked server.

    May be this will help someone.

    Shamshad Ali

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply