Using Excel VBA to Copy an ADODB Recordset to Multiple Worksheets

Microsoft VBA logo

In adding functionality to an ancient Excel VBA reporting app for an Oracle database, I decided to set up a temporary worksheet to use as a place to store data before copying it to multiple other worksheets rather than copying directly from the recordset multiple times. Basically, this VBA procedure takes an ADODB recordset and … Read more

Storing Session State for an ASP.NET Site in a SQL Server Database

ASP.NET and related technologies

When using session state in an ASP.NET Web application, you have several options. If you want to store it in your application database, as opposed to the ASPstate database (created at the command line with “aspnet_regsql -S [server] -E -ssadd -sstype c -d ASPstate”), I have scripted the database objects and stored them in GitHub … Read more

Fixing the “Unknown Error code during application install: ‘-24′” Issue

Android Jelly Bean logo

I just finished installing the CyanogenMod ROM for Android Jelly Bean 4.1.2 (cm-10-20130117-1903-otter-sgt7.zip) on my rooted 1st generation Amazon Kindle Fire. I am very pleased to say that it boots much faster than the stock Amazon-loaded OS (forked Android Gingerbread 2.3)! Loading another ROM removed the Amazon Marketplace, but does not load Google Play. After … Read more