VS2012 BI Installer error - Rule "Same architecture installation" failed.

I was trying to upgrade my Visual Studio 2012 to allow editing Business Intelligence projects by installing SQL Server Data Tools (thread on that topic), so I downloaded this installer for the SQL Server Data Tools and chose an existing SQL Server 2012 instance to install to, then I got this error 'Rule "Same architecture installation" failed.'

After some searching it appears that you need to choose to perform a "new installation".

Here are the links where I found this information:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4ae33edc-c1ad-44df-bc74-ffb30ea91287/64-bit-microsoft-sql-server-data-tools-business-intelligence-for-visual-studio-2012-?forum=sqlreportingservices

http://blogs.msdn.com/b/jenss/archive/2013/03/07/finally-the-family-united-sql-server-bi-project-templates-now-available-in-visual-studio-2012.aspx

Any CPU

Could not load file or assembly '<name>' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Ran into the above error, found this post.  Changed from x86 to Any CPU, and it worked!

IIS Enable 32 bit applications "HTTP Error 500.19 - Internal Server Error"

http://forums.iis.net/t/1149768.aspx

"You cannot get rid of it for that site - compression schemes are registered globally - to get rid of the scheme altogether, run below
%windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpCompression /-[name='xpress']"

RE: Quickbooks QBFC 80040154 "Co-Create error"?

Previously I had problems getting a desktop application to integrate with QuickBooks on a 64 bit Windows Server 2008 operating system running IIS 7.0.  Recently I've moved my development Website to the same 64 bit machine, and I was experience same problems with getting my .Net website to be able to use the QuickBooks QBFC8 Library.  Thanks to some experience from before I knew I should see if this was a problem going from 32 Bit to 64 Bit.  It was.  I had to "Enable 32-bit Applications" in the Advanced Settings on the Application Pool.

Windows 7 64 bit and SQL Server cliconfg

I recently did a wipe and Windows 7 install.  Installed all my dev tools, then tried connecting to some SQL Servers, local and remote, local worked fine.  I added some remote servers to my cliconfg by running (windows run dialog) 'cliconfg' it brought up the familiar server alias configuration tool, so I added my servers.  Then I tried logging into some of them, no luck.  Totally confused.

Turns out there are two cliconfg dialogs, a 32 bit and a 64 bit one, I had been getting to the 64 bit one, but my sql server management studio had been using the values from the 32 bit one.  Found the 32 bit one in "C:\Windows\SysWOW64\cliconfg.exe" started using it, and everything worked, still pretty annoying, I wish they would at least warn you, "oh hey, by the way, there are actually two cliconfgs"

Kind of silly.

*Edited, I had my cliconfg locations mixed up, I had assumed the one found in the folder referencing the number 64 would contain the 64 bit version.  This is wrong, though I remain confused because my brain refuses to believe the System32 folder on 64 bit windows would contain the x64 exe and the SysWOW64 directory would contain the x86 exe.  Thanks to Niels Grove-Rasmussen for the catch.

QuickBooks SDK 8.0, QBFC8 and Windows Server 64 Bit

Was having problems with QB SDK 8.0 not working properly, discovered via intuit developer forum that I needed to force x86 compilation instead of "Any CPU".  Was getting an error similar to "Could not find the COM Class with CLSID *****-******....".  Switched the compilation method to x86 explicitly, and it started working.  Yay!