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