MSXML: Access is denied – 80070005 – MSXML4.dll

Recently, I wanted to see if my ex in DC was reading my blog so I ran my referer log against an outdated copy of the MaxMind GeoIP locator database. I figured the database could use some updating so I ran the ImportMaxMindGeoIP.vbs script I posted awhile back, and much like in real life, I received an “Access Denied” error.

Line 63 was basically a simple line that stated: objXMLHTTPindex.Send() Most of the access denied errors on the net referred to POSTing unencrypted data but the script was performing a GET. After about a half hour of troubleshooting, I realized that the URL my script was pointing to was returning an HTTP code of “301: Moved Permanently.”

Once I plugged in the new updated URL, the script worked without a problem. So if you’re receiving a similar error, be sure to check that the URL hasn’t been moved. You can do this by using Sam Spade, Firefox Extensions or just loading up the URL in your browser and seeing if it’s redirected to a new location.

As for knowing if the ex is reading my blog, the results were inconclusive. I guess I’ll find out soon enough. I mean, I could just ask her, but what’s the fun in that? ;)

Chrissy is a PowerShell MVP who has worked in IT for nearly 20 years, and currently serves as a Sr. Database Engineer in Belgium. Always an avid scripter, she attended the Monad session at Microsoft’s Professional Developers Conference in Los Angeles back in 2005 and has worked and played with PowerShell ever since. Chrissy is currently pursuing an MS in Systems Engineering at Regis University and helps maintain RealCajunRecipes.com in her spare time. She holds a number of certifications, including those relating to SQL Server, SuSE Linux, SharePoint and network security. She recently became co-lead of the SQL PASS PowerShell Virtual Chapter. You can follow her on Twitter at @cl.

Posted in VBScript
4 comments on “MSXML: Access is denied – 80070005 – MSXML4.dll
  1. Trevor says:

    “I wanted to see if my ex in DC was reading my blog so I ran my referer log against an outdated copy of the MaxMind GeoIP locator database”

    Yep, we’ve all been there….

    *cough*GEEK*cough*

  2. bryan says:

    i am so glad i’m not the only one….

  3. Chrissy says:

    Haha..so thought I was the only one too! Let’s start a support group.

  4. BIT says:

    hahahah… it was so simple !! Thanks a lot, you saved me a lot of time !!!!!!!

Leave a Reply

Your email address will not be published. Required fields are marked *

*