Visual Studio 2005 64-bit error (incorrect format - HRESULT: 0x8007000B))

I was working through some SQL Compact Edition tutorials and kept getting errors trying to run the most basic of applications.  "An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)".  This was running on my 64-bit Vista laptop.  My regular 32-bit desktop with Windows XP worked fine.  So was it Vista or 64-bit.  This time, it was 64-bit.  The solution was to go into the project properties and set the "Platform Target" to "x86" instead of "Any CPU".  Setting it to x64 gave the same error as well so I'm not sure what the fix is to get it to run true 64-bit apps without the error. The problem may be SQL 2005 CE but I don't think so.  But for now, changing the "Platform Target" got me past my problem.

Installing SQL Server 2005 replication for SQL CE

If you're trying to install the SQL 2005 Compact Edition Server Tools, on of the pre-requisites is the SQL 2005 Replication Tools.  That seems simple enough but finding where to install that gave me fits.  Finally I found a Microsoft link that showed me where it was located.

  • In the SQL Server Installation Wizard, on the Components to Install page, click Advanced.

  • On the Feature Selection page, click Client Components, and then click Connectivity Components to install the SQL Server 2005 replication components

Google Analytics with SubText

I could not figure the best way to add Google Analytics to my SubText site.  I thought of adding it to a skin which would be easy enough but I needed it on a "per blog" basis, not "per skin".  Then I found Mladen Projdic's blog post that solved the problem.  It's really quite simple.

In the "Admin" for your blog, click on "options" and there you'll find the section for Static News/Announcements.  Just drop your Google Analytics script code right there and that's it.  Nice and simple and "per blog".  No code change required!

Multiple blogs on SubText

Are you new to the SubText blogging package and not sure how to set up multiple blogs on a single install?  I love SubText but I was stumped by how to set up multiple blogs.  At, the Docs gives a detailed explaination of what's happening in the app and database code but was I suppose to start manually updating the database?  Turns out "no".  Just add /hostadmin to the initial URL you set up and log in with your original username/password (i.e.  http://<yourSubTextURL>/hostadmin ).  This gives you an easy interface to create multiple blogs.  Piece of cake if you know what to do.

On an embarrasing side note, this is clearly documented at if you go to the "Configure" section of the "Documentation". But you do have to actually go and read! 

Visual Studio 2005 "release build" option missing

While working on my SubText web site, I realize I accidentally deployed my code in debug mode.  So I opened up VS 2005 to build as a "release" and redeploy.  Surprise, I had no "release" option only a "debug" option in Configuration Manager.  After searching and searching, I finally found this post on K. Scott Allen's blog about the differences between 'release' and 'debug' builds.  The problem (or maybe "cause" is the right word) stems from the fact that I had set the debug mode in the web.config.  According to Scott..

This new compilation model makes the Configuration Manager for a web site obsolete. The only option appearing in a Visual Studio 2005 web site “project” is a Debug configuration. Don’t fret – it means nothing. The web.config file now rules the school.

Now, I know I've had "debug=true" in many of my web.configs and I don't remember the "Configuration Manager" taking the release option away but that certainly seems to be the case now.  I hope this saves you some time trying to track this down.

Sharepoint 2007 and SQL 2000 Reporting Services don't work together

Like many others, we had Sharepoint Portal Server 2003 and SQL 2000 Reporting Services on the same server.  Searching the Internet and install guides mentioned nothing about it being a problem but after I upgraded to MOSS 2007 SQL 2000 Reporting Services was dead.  After digging in, the problem is that SQL 2000 Reporting Services runs under .NET 1.1 and the key is it has to run under the "Default Web Site" in IIS.  MOSS 2007 upgrades the "Default Web Site" to .NET 2.0.  That causes all sorts of problems for SQL 2k RS.  A call to Microsoft came up with no workaround.  I'll give more details on the specifics if anyone is interested, but in won't work.

So what's the fix?  The fx is to upgrade to SQL 2005 Reporting Services.  The good news is you don't have to upgrade Sharepoint to SQL 2005.  You can, but if you where like me and in a hurry to get SQL RS going you probably want a little more time to plan for that process.  The way to do it, is to first backup you SQL 2000 RS DB's and then simply insert your SQL 2005 CD.  Don't select any other option but Reporting Services and let is upgrade the default instance.  This will upgrade the Reporting Services engine and upgrade the web site to .NET 2.0 and that will play quite nicely with MOSS 2007.  Hope this helps someone out.

Pages: Prev1...3456NextReturn Top