Jul 11

Uninstall an assembly from the GAC: Access Denied

If you’ve encountered this problem, you probably did a Google search. You must have noticed there isn’t alot of solutions which have worked for you. Here’s something that has worked for me.

In the command prompt, I executed the following code:

Uninstall an assembly from the GAC: Access Denied
That annoying c:\windows\assembly folder

This code allows you to browse the GAC as in Windows Explorer instead of the GAC viewer. The second portion of the script creates a folder named “gacview” in the assembly folder, which allows you to browse the GAC in the old fashion way. This way, you retain the advantages of both world.

Once you can browse the GAC with Windows Explorer, you can find your assembly, and manually delete it, and no security will prevent you from doing so.

I don’t know if there are repercussions to this, I don’t know if it’s a good practice or not. My guts tell me it’s a hack, so it’s probably not a good practice, but it’s the only thing that worked for me.

2,039 total views, no views today

May 03

Tethering HTC Desire on Orange

From your homescreen;

Menu/settings/Wireless&Networks/Mobile networks/Access Point Names

You should see the following three APNs;

  • Orange Internet
  • Consumer Broadband
  • Orange MMS

Select Consumer Broadband

CHANGE the APN from “consumerbroadband” to “orangeinternet”
CHANGE the Username from <Not set> to “Orange”
CHANGE the password from <Not set> to “Multimedia”

Make sure you use the capital first letters exactly as I’ve typed them there.  Oh, and don’t type the ” marks.

Authentication type should be set to CHAP.  Make sure, I think it was anyway but just check.
Press your Menu button, tap “Save”

Re-boot your phone and that’s it.

Switch on your “Wifi Hotspot” in your usual way, search and connect from your laptop.  Meanwhile your phone keeps its own connection side by side your tethered hotspot – that’s what the “Orange Internet” settings alter, so don’t mess with those.

Don’t forget to use one of the WPA security methods of course, otherwise some cheeky chappy will definitely enjoy your Orange account’s data.

1,384 total views, no views today

Mar 27

SharePoint CAML Tip

When using CAML to query a list make sure that <And> & <Or> tags have exactly two elements.

807 total views, no views today

Dec 02

OpenXML Excel Quirk

I have discovered a nasty gremlin when using the OpenXML SDK to read data from an Excel SpreadSheet.

While reading the cells in a row using the OpenXML SDK I discovered that that the collection of Cells returned for a given Row is sparse (i.e. has missing cells)

In the Sheet I was processing In Row 58 Cells B58, C58 & D58 are empty, A58 & E58 contain strings.  If you look at the XML fragment below you will see that there is no XML for Cell C58 in the XML

The really weird thing is that Cells B58 and D58 are also empty

This really messed up things as I needed a string array with values in the correct column indexes

The code I ended up with to convert the row to a string array is listed below

How to get at the raw XML

As most of you should know (by now) the new Office 2007+ format is a container for a set of files (which are mainly XML) stored in compressed zip format.  Hint: To see the files inside rename an .xlsx file to .zip, then examine the contents using WinZip or similar and will be revealed.

1,344 total views, no views today

» Newer posts