ABCPdf Unable to load DLL ‘ABCpdf8-64.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

I use the ABCPdf .Net module quite a bit in projects.  It’s perfect for generating and manipulating PDF files in server-side ASP.Net code.  But more than once, I’ve encountered this error and can’t remember the solution.  Finally I remembered the cause of the error.  You have to enable 32-bit applications in the IIS application pool here. Go into IIS Manager and choose Application Pools. Find the app pool assigned to the site running ABCPdf.   Select the App Pool on the left, then click 'Advanced Settings’ on the right side. No...

Aug 31, 2012 READ MORE
Slick little GeoIP feature for the AbleCommerce Order Manager

Came up with an awesome mod for the Order Manager screen tonight.  It highlights orders that are placed from non-US IP addresses.  This makes it incredibly easy to identify potential fraud orders in your storefront. This mod works with a local GeoIP database too, so there’s no lookup limits or bandwidth spikes to worry about. Geographic IP lookups are a dime a dozen on the internet.  But the vast majority of these lookup sites will throttle the number of requests.  This creates a slow and often frustrating limit on the usefulness in a production environme...

Aug 28, 2012 READ MORE
ASP.Net Gridview how to make entire row a link

I found this today and was completely floored in it’s simplicity.  Works like a charm: protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string ProductId = DataBinder.Eval(e.Row.DataItem, "ProductId").ToString(); string Location = ResolveUrl("~/Details.aspx") + "?ProductId=" + ProductId ; e.Row.Attributes["onClick"] = string.Format(&am...

Aug 06, 2012 READ MORE
SQL 2008 R2 in an Amazon EC2 virtual instance reports UTC with GetDate()

Ran into the most curious issue after migrating live sites running SQL 2008R R2 into Amazon AWS virtual instances.  There was a job scheduler module that populated a queue table based on triggers from other tables. The triggers used the T-SQL GETDATE() function to log the current datetime of the transaction being triggered.  However, after migrating SQL to a virtual instance, the “current” datetime was off.     The trigger code was seeing the wrong datetime value every time GETDATE() was called. I even went so far as to light up a loca...

Aug 01, 2012 READ MORE