Problems connecting to SSAS 2005 from Excel 2003

Today I was trying to connect to SSAS 2005 cube from Excel 2003 and I was not able to do so using the exisitng OLAP 8.0.

I had to download the folowing to resolve the problem.

1. Microsoft Core XML Services (MSXML) 6.0 SP1
2. Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

I have followed the article on Microsoft downloads http://support.microsoft.com/kb/940167

and that solved my problem !

Internal Domain Redirects with ASP.net and C# (C-sharp)

An extremely useful article explaining how to issue internal domain redirects in ASP.net, through modifying global.asax.

read more |

Terminate User processes in SQL Server

This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.

read more |

Custom Error Handling in ASP.net C# (C-Sharp)

An article offering a nice solution on how to properly set up custom error handling in ASP.net.

read more |

CopyFileEx With Progress Callback in 20C

This article will show you how to call unmanaged DLL functions from C#. It will specifically walk through how to call CopyFileEx with a callback to report progress.

read more |

Flash vs Silverlight: Laser Orbit

A stunning effect with a laser orbiting around the mouse! In this example, it demonstrated the difference in dispatching Event between AS3 and C#.It included both Flash and Silverlight versions with complete source codes.

read more |

Creating 3D and 2D Interactive Web Content

Learn and read more about this 3D platform, that is web-based (supports most common browsers)!

read more |

Collections of Internet Resources for Software Developers

As a software developer, you need to constantly update your knowledge on new software technologies and new career opportunities for your own career development. This requires you spending time on search and find information on software technologies and career opportunities. This collection of Internet resources will help your to locate the informat

read more |

How To Watch YouTube Videos In High Quality

The technique to view youtube videos in higher quality is extremley simple and can be applied to any youtube video, it will however only work directly on the youtube website and only for some videos reportedly all after 2006.

read more |

Flash Quiz - Create your own free quiz

Want to create a quiz for your website but don't have the skills? This free software lets you quickly create and customise your very own multiple choice quiz. Just download the software and use the step-by-step wizard.

read more |

Grade your website

Website Grader is a free tool that measures the marketing effectiveness of a web site. The tool provides a score that incorporates elements such as web site traffic, SEO, social popularity, and other technical factors. This is a great tool when it comes to gaining an idea about what's working well and what could be improved on your site.

Scheduling a SSAS backup on SQL Server 2005

Today I had a requirement to schedule a backup on SQL Server Analysis Services. Here is the link that I found very useful for me. SSIS package to backup SSAS databases

Copying records from database into another -- SQL

I had this requirement today where I had to copy from a table in one database into a similar table in another database.

the code I have used in

[code]
insert into database1.dbo.table1 select * from database2.dbo.table1 where xxxxx
[/code]

where xxxx is the criteria that you need to add.

Precautions you have to tak before you do this.

Backup the database into which you are copying the record so that you can restore if something goes wrong.
Copy contents when there are no other transactions being entered into the database1

Amazing Free Website Template, Table less Website

Free table less or div template of Website Brewers... Cool website layouts with psd files, ie6 and firefox compatible. Ready to used to CMS template such as Wordpress or Joomla. Other templates includes Flash Slideshow and FLA File. You can also used on static pages... CSS Style Sheet have description and comments. The images are optimize by 80%.

read more |

Water Text Photoshop Tutorial

Learn how to create a text with "water" effects.

read more |

20+ Ways to Make Money Creating Online Cartoons

Various methods of using animation to make money, a few I am sure you expect and perhaps a couple you haven’t yet considered.

read more |

Learn, discuss and explore the realm of Graphic Design

Useful resource for designers. Interesting articles.

read more |

Mastering Visual C# .NET

Mastering Visual C# .NET is the best resource for getting everything you can out of the new C# language and the .NET Framework. You'll master C# language essentials, quickly taking advantage of the many improvements it offers over C++ and see tons of examples that show you all the ways that .NET can make your programming more efficient !I have already downloaded it.

read more |

XML in 10 points

If you are new to XML, it may be hard to know where to begin. This summary in 10 points attempts to capture enough of the basic concepts to enable a beginner to see the forest through the trees.

read more |

Open Book Tutorial

In ten simple steps, this tutorial teaches you how to design a simple but an effect open book design that can be used either for your flash autobiography or as a splash page for your website. This tutorial can even be accomplished by beginners so go ahead and give it a try!

read more |

Flower Photoshop Brushes

Free for download at gfxfever.com

read more |

Filemail - Email Large Files

Filemail is a nice online service,which allow you to send 2GB email attachments

read more |

7 Incredibly Useful Tools for Evaluating a Web Design

If you are interested in analyzing and optimizing your page layout - here are some extremely useful tools that you can use to help.

read more |

15 Watercolour Photoshop Brushes

A great collection of 15 watercolor photoshop brushes

read more |

Tutorial Photoshop: Reflection

A new Photoshop tutorial explaining you how to create this reflection effect on a text.

read more

List of SQL Server database users and permissions

Today I was doing some research as to how to list the database users and the permissions they have and came across this article which is very useful.

http://www.mssqltips.com/tip.asp?tip=1071

Test you site in different browsers...

If you are interested to test your website in different browsers then Browsershots is very helpful for you. Browsershots shows how your website looks in different browsers. It is very easy to use. Just go to Browsershots site and then submit

read more | digg story

Introduction to C++ Programming and Graphics: Download ebook

Introduction to C++ Programming and Graphics offers a venue for rapidly learning the language by concisely revealing its grammar, syntax and main features, and by explaining the key ideas behind object oriented programming (OOP), with emphasis on scientific computing. The book reviews elemental concepts of computers and computing..

read more