Monday, February 06, 2012 | |
RT-blog
Author: Ron Smith Created: 9/12/2007 10:44 AM
Thoughts on and experiences with computers, programming and electronics.

Visual Studio 2008: Unable to start debugging on web server. An authentication error occurred...
By Ron Smith on 1/8/2009 4:10 PM

My dev server is a Win 2003 machine with IIS 6.0.  I've got a number of web sites set up which I reference via URLs such as http://site1.localhost, http://site2.localhost, etc.  By putting entries in my HOSTS file which point back to 127.0.0.1, I can use those URLs to access the sites because I set up Host Headers for each site to look for its specific URL.

After installing VS 2008, I suddenly lost the ability to debug web applications on my local machine.  I had been using VS 2005 successfully before that.

"Unable to start debugging on the web server. An authentication error occurred while communicating with the web server."

I did a lot of fruitless searching on the web.  None of the solutions worked: Integrated Windows Authentication must be ...

Comments (5) More...

The attribute key cannot be found - SSAS 2005 dimensions
By Ron Smith on 7/16/2008 6:50 AM

Another gotcha in Sql Server Analysis Services (SSAS) 2005 related to nullable foreign keys...

Let's say you have DimensionA which contains a foreign key to the related dimension DimensionB and that relationship is optional (nullable foreign key).  DimensionB is represented as AttributeB within DimensionA.

When I first created DimensionA and related it to my fact table, everything worked nicely.  I then decided to have the name column for AttributeB show the text value for DImensionB's key rather than they key itself.  I figured this would make things go more quickly when building reports. I used object binding on the NameColumn and set the source table and source column.  Suddenly I started getting the error "The attribute key cannot be found" when I tried to process the cube.  Huh?

I checked my source tables and of course the key did exist.&a ...

Comments (0) More...

Optional relationships in SSAS 2005
By Ron Smith on 7/15/2008 1:16 PM

On a recent project using Sql Server Analysis Server (SSAS) 2005, I ran into some challenges with fact tables that had optional relationships (nullable foreign keys) to related dimension tables.

I used a design were FactTableA had a regular relationship to DimensionA and DimensionB, however, these were both optional relationships.  The cube functioned correctly until I added a referenced relationship to DimensionC via DimensionA.  When I did this, the count of records in FactTableA suddenly dropped to a value corresponding to the count of non-null values for the foreign key referencing DimensionA.  The cube was forming an inner join between FactTableA and DimensionC via DimensionA; not what I wanted at all.

The fix was simple, in the "Define Relationship" screen for DimensionC, I unchecked the "Materialize" checkbox. The documentation doesn't mention this impact on the dat ...

Comments (0) More...

RadioButtonList - hanging indent (ASP.Net)
By Ron Smith on 6/9/2008 12:49 PM

Here's how to make hanging indents for radiobuttonlists in ASP.Net!

You must choose RepeatLayout="Table" and then create styles to apply to that table.

[Test in IE7 and Firefox 2]

<style type="text/css">
    .rbChoice input { margin-left: -20px; }
    .rbChoice td { padding-left: 20px; }
</style> 

<asp:RadioButtonList
ID="RadioButtonListSessionChoice"
runat="server"
CssClass="rbChoice"
RepeatLayout="Table"
RepeatColumns="1"
/>

Comments (1)

iMac: Buyer beware
By Ron Smith on 5/16/2008 6:48 AM

I love my iMac, I hate my iMac.

I've owned my iMac for about 2 years.  I use it for music and photos, mostly, and when it's not in use it makes a great picture frame for displaying my photos.

BUT

My LCD screen suddenly started devloping vertical lines just like these.

So, while I love my iMac - don't buy one unless you get the extended AppleCare warranty!

Here's an online petition to get Apple to correct this problem. (yeah right)

Comments (0)

iConcertCal - Cool iTunes plug-in
By Ron Smith on 10/5/2007 11:10 AM
iTunes plug-in for finding live music.
Comments (0) More...

QuickBooks Pro Timer (2007)
By Ron Smith on 9/26/2007 9:15 AM
Stand-alone timer program is not present in QuickBooks 2007 download file
Comments (4) More...

FrontPage: the server "" timed out
By Ron Smith on 9/25/2007 8:48 AM
Solution to the FrontPage error: the server "" timed out. Related to poorly formatted webbot include files.
Comments (1) More...

PrintPrint  
Search
Archive
Copyright 2009 Real Technology | Terms Of Use | Privacy Statement Home | RT-Blog | Contact Us | About RT