Month: December 2007

After setting up an aspx page that accepts IPN postings from PayPal on my domain, I got this error when trying to post IPN data:

The remote server returned an error: (999) No Hacking

Well, I didn’t have this problem with my previous hosting company, nor when trying on my local IIS web site. So I contacted Webhost4Life, on their live chat support. That didn’t help much. But I finally found the solution.

It turns out that Webhost4Life has a functionality called Security Guard. Turning this off for my sub domain did the trick.

You will find the Security Guard in your Control Panel, Security section.

I have been struggling with this for a couple of hours now. Now matter what options I set in the Microsoft SQL Server 2005 Import and Export Wizard, I cannot manage it to correctly transfer my identity columns.

It turns out that this is a bug in SQL Server 2005. There are a couple of proclaimed workarounds like this and this. However that didn’t work for me. I cannot uncheck the “Optimize for Many Tables”, because if I do, I get a lot of other key errors when the package runs.

So I stumbled upon this utility, the Simple SQL Bulk Copy.

It worked great! My tables containing identity columns was transferred correctly.