Could not load file or assembly ‘System.Web.WebPages, Version=2.0.0.0

Recently I moved an AbleCommerce Gold R12 install to Windows Server 2019. Immediately the RESTful Web API built into the app started responding with 404 errors. It was as if the MVC routes simply no longer existed even though they were clearly being built in the web api bootstrap code. Fast forward to today as I deploy a minor unrelated update to another DLL. As part of that update, the System.Web.WebPages dll was also deployed. Something recently had updated that DLL. While everything worked locally, suddenly the .Net application was throwing 500 errors. Couldn't even get an Except...

Jan 10, 2020 READ MORE
Hosting Classic ASP on Server 2008 R2

Ran into a problem today trying to light up a Classic ASP site that was a copy of an existing site on the same server. However HTTP 500 errors were all we could get. Once we enabled debug logging in ASP, we saw that there was a problem with the ADODB connection being able to open the MSAccess database within the site folders. Gotta remember to enable 32-bit apps in the application pool advanced settings. Note: Microsoft Access databases have been popular for many years with developers who use Active Server Pages (ASP) for small-scale applications, but Microsoft Access databases are n...

Nov 25, 2019 READ MORE
How to speed up site rebuild after compiling a DLL

Came across this little gem this morning.   Made a significant difference on my PC. Here’s the best one. Add this to your web.config for MUCH faster compilation. <compilation optimizeCompilations="true"> Quick summary: we are introducing a new optimizeCompilations switch in ASP.NET that can greatly improve the compilation speed in some scenarios. There are some catches, so read on for more details. This switch is currently available as a QFE for 3.5SP1, and will be part of VS 2010.The ASP.NET compilation system takes a very conservat...

Nov 25, 2019 READ MORE
Building an Audit Log with nHibernate Listeners in AbleCommerce

I have a client who can’t seem to figure out who’s making edits to certain products. Somebody changed the price, somebody marked it hidden. That sort of thing. Too many people in the back-end and no audit trail for who changed what. So I decided to dig into nHibernate listeners. After a brutal all-nighter reading StackOverflow posts and copying snippets from a few blog posts, I actually got it working. I added some new handlers for the Post-Commit-Create, Post-Commit-Update and Post-Commit-Delete listener events and pointed them to my AuditEventListener class. These are easily wired ...

Nov 25, 2019 READ MORE
Leveraging the Gift Wrap feature for optional upcharges to a product

Just goes to show, you still can teach an old dog new tricks. A client needed a way to add an Engraving choice to the product page.   Normally this isn’t an issue, just use the product variant feature. But in this case, the engraving choice must be optional.   And it has to charge an amount.  And it needs to accept some text for the actual engraved words. So after a little digging, I settled on a little-used feature in AbleCommerce known as Gift Wrap.    Gift Wrap is a way to associate a secondary charge to any product.   The basket ...

Nov 25, 2019 READ MORE
QuantumView API with AbleCommerce

Recently a client requested a challenging project.  They wanted to fully automate the processing of tracking numbers pulled from the QuantumView API data feeds. The majority of the client’s shipments are drop-shipped direct from the manufacturer or distributor who charge my client’s UPS account number.   This is a technique known as 3rd-party billing.  This works well because my client can leverage all of their shipping volume with UPS instead of just the in-stock shipments.   And they know what to expect for shipping charges since it’s their account being billed. However ther...

Sep 25, 2018 READ MORE
TortoiseSVN missing icons in Windows 7

Been scratching me head for a while now as to why my Windows Explorer icons for TortoiseSVN were suddenly missing. After some digging, it appears that DropBox updated itself and added some more shell overlay extensions.   Since Windows 7 only supports 11 overlays, this pushed the Tortoise icon entries too low in the list. The solution was simple:  edit the registry hive: HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionExplorerShellIconOverlayIdentifiers and remove the unwanted registry entries so that the TortoiseSVN entries are in the first 11 found. &nbs...

Jan 13, 2015 READ MORE
SHA2 Supported Windows Platforms

Found a nice page today that easily identifies what platforms support SHA2.   SSL Supported Platforms...

Jan 08, 2015 READ MORE
SQL 2012 Management Studio hangs clicking Files menu during database restore

I’ve had this nagging issue for months now.   Every time I go to restore a database from a backup file, I cannot click the Files menu in the left sidebar.   This didn’t happen in SQL Server Management Studio 2008.    But it happens every time in SQL Server Management Studio 2012. I enjoy using SSMS, it works well for my needs.  So it got very frustrating that it would lock up when I needed it most. I finally took the time to research and thought maybe a newer version had been released since I downloaded it.  ...

Jul 25, 2014 READ MORE