How to set up build server for Interop projects?

Feb 22 2013 8:19 AM
I am trying to set up a build server (based on Hudson). A number of the projects I want to build contain Excel interop features. 

On my development machine I have VS 2010 Professional and I installed Visual Studio Tools for Office. 

On the server, I installed .Net SDK 4.0 and the Visual Studio Tools for Office. When the build runs I get the error below. 

Can anyone tell me what is missing or not properly configured? Thanks!

Project "E:\build-deploy\.hudson\jobs\AuthorisationViewer-Build\workspace\VSTUDIO\AuthorisationViewer\arburgauthviewer\arburgauthviewer.csproj" on node 1 (default targets). ResolveAssemblyReferences:   Primary reference "Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c". C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(1360,9): warning MSB3245: Could not resolve this reference. Could not locate the assembly "Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. [E:\build-deploy\.hudson\jobs\AuthorisationViewer-Build\workspace\VSTUDIO\AuthorisationViewer\arburgauthviewer\arburgauthviewer.csproj]           For SearchPath "{CandidateAssemblyFiles}".           Considered "log4net.dll", but its name "log4net" didn't match.           For SearchPath "{TargetFrameworkDirectory}".           Considered "C:\Program Files\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "C:\Program Files\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\Microsoft.Office.Interop.Excel.exe", but it didn't exist.           For SearchPath "{Registry:Software\Microsoft\.NETFramework,v4.0,AssemblyFoldersEx}".           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Platforms\x64\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Platforms\x64\Microsoft.Office.Interop.Excel.exe", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Platforms\Win32\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Platforms\Win32\Microsoft.Office.Interop.Excel.exe", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Platforms\Itanium\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Platforms\Itanium\Microsoft.Office.Interop.Excel.exe", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "C:\Program Files\MSBuild\Microsoft.Cpp\v4.0\Microsoft.Office.Interop.Excel.exe", but it didn't exist.           Considered "C:\Program Files\Microsoft Chart Controls\Assemblies\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "C:\Program Files\Microsoft Chart Controls\Assemblies\Microsoft.Office.Interop.Excel.exe", but it didn't exist.           For SearchPath "{GAC}".           Considered "Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c", which was not found in the GAC.           For SearchPath "{RawFileName}".           Considered treating "Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" as a file name, but it didn't exist.           For SearchPath "bin\Release\".           Considered "bin\Release\Microsoft.Office.Interop.Excel.dll", but it didn't exist.           Considered "bin\Release\Microsoft.Office.Interop.Excel.exe", but it didn't exist.

.......

Build\workspace\VSTUDIO\AuthorisationViewer\arburgauthviewer\obj\Release\GeneratedInternalTypeHelper.g.cs 
Lib\ExcelGenerator.cs(5,17): error CS0234: The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) [E:\build-deploy\.hudson\jobs\AuthorisationViewer-Build\workspace\VSTUDIO\AuthorisationViewer\arburgauthviewer\zmxxgbhf.tmp_proj] 



Answers (2)