January 2007 - Posts

Top 10 (*cough 14*) Essential Resources for SharePoint Developers
24 January 07 08:47 | Simon Phillips | with no comments

Randalli has posted, on the MSDN SharePoint Content and Resources site, a Top 10 list of the resources that Microsoft have been producing for MOSS and WSS 3.0.

10 Essential Resources for SharePoint Developers

SQL Reporting Services: Using Parameter Queries with Oracle Sources
09 January 07 08:10 | Simon Phillips | with no comments

I came across this today when I tried to create a report in SQL Server Reporting Services against an Oracle database using the Oracle .Net Provider.

Against SQL you can define parameters in the report query using @paramname syntax. This doesn't work against an Oracle database. It took me a while to remember how to define named parameters in PL/SQL (It has been near to 9 years since I've touched PL/SQL) which is :paramname rather than @paramname then everything starts to works again.

Error trying to browse cubes with SSMS
02 January 07 01:11 | Simon Phillips | with no comments

First of all Happy New Year everyone!!

Every since I've moved to Office 2007 and uninstalled Office 2003, I've been having problems when I try and browse Cubes in Microsoft SQL Server Management Studio (SSMS).

I was getting the following error

Class not registered (Exception from HRESULT:0x80040154 (REGDB_E_CLASSNOTREG))

After a quick browse on the web, it seams that I uninstalled the Office 2003 Add-in: Office Web Components (OWC) and this is what the Cube Browser was looking for.

The OWC can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252c-402e-4f72-97a5-e0fd290d4b76&DisplayLang=en

This Blog

Applications / Addons

Irish Community

Microsoft Ireland Blogs

My Articles

Syndication