How to create an Excel Workbook from an SQL database using Open XML SDK 2.0

Published on

Below is the C# code to create a new Excel workbook based on a template file & populated by an SQL database. You need to add references to: DocumentFormat.OpenXml System.Data.Linq Windows.Base using System; using System.IO; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Spreadsheet; using DocumentFormat.OpenXml; namespace ElitetoExcel { class Program { … Continue reading How to create an Excel Workbook from an SQL database using Open XML SDK 2.0

SQL 2008 Server Error HRESULT E_FAIL has been returned from a call to a COM component when browsing the cube

Published on

You get the following error when trying to browse the cube from SQL Managment Studio or from Visual Studio 2008: Error HRESULT E_FAIL has been returned from a call to a COM component The error is a bug in SQL 2008 server, it occurs when your server language is different to the language set on … Continue reading SQL 2008 Server Error HRESULT E_FAIL has been returned from a call to a COM component when browsing the cube

Platform Error: System.Exception: Action Microsoft.Crm.Setup.Server.RSConfigAction failed

Published on

When installing MS Dynamics CRM 4 on a SQL 2008 server you may get the following error: “The specified path is not a metabase path.” Platform Error: System.Exception: Action Microsoft.Crm.Setup.Server.RSConfigAction failed. This issue occurs when the path of Reporting Services does not exist on the server. To work around this issue, create a Web site … Continue reading Platform Error: System.Exception: Action Microsoft.Crm.Setup.Server.RSConfigAction failed

K2 Blackpoint now supports Windows 2008 server & SQL Server 2008

Published on

Now K2 blackpoint is supported on Windows Server 2008 and on SQL Server 2008! The KB470 update just released on the K2 customer portal provides this support. KB000470 updates all K2 blackpoint 0902 version 4.9040.1.0 installations with latest product hotfixes. The installer will update K2 blackpoint 0902 32-bit and 64-bit installations.