Bob The Janitor's questions

Trying to get all of the groups and nested groups for a user when authentication with ADFS

basically I have a structure like this

• group1 -> subgroup1, subgroup2
• group2 - >subgroup3, subgroup2
• group3 -> subgroup1, subgroup4

if I add Group1 and group3 to my user I would like to get back

• group1
• subgroup1
• subgroup2
• group3
• subgroup4

I have this query

c:[Type == "http://schemas.microsoft.com/ws/2008/06/identity/claims/windowsaccountname", Issuer == "AD AUTHORITY"] => issue(store = "Active Directory", types = ("http://schemas.microsoft.com/ws/2008/06/identity/claims/role"), query = ";tokenGroups;{0}", param = c.Value);

but it only returns group1, group3

Is there any real reason to upgrade my web servers from windows server 2008 to server 2008 R2? I know I get a new memory manager and IIS 7.5 but what are the actual advantages vs marketing hype.

I'm running windows xp 64, which is really xp over server 2003, It runs iis6, which is capable of running multiple websites, but the XP version doesn't let me, I would assume this could be changed with a registry edit? any Ideas?

I can't open an Excel spread sheet with .NET on an x64 server using the following connection string

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filePath + "; Extended Properties=Excel 8.0;"

I get The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

I installed the 2007 Office System Driver: Data Connectivity Components and tried with Microsoft.ACE.OLEDB.12.0 and this connection string

"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + filePath + "; Extended Properties=Excel 8.0;"

and got "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

I searched Google with the only response being it's a 64 bit problem, anyone have an Idea how to fix this?