Friday 9 May 2008

Windows Update and Error 0x8DDD0018 -FIX

I was having a hell of a time trying to get a Windows 2003 R2 Standard x64 server to load the Windows Update site. I was always getting the error: 0x8DDD0018

Sadly, the troubleshooting info at MS focused on starting the BITS service which (seemingly) was working just fine.

Well, I eventually stumbled on the solution. Try this at a command prompt:
regsvr32.exe wuaueng.dll

Presto! Windows Updates should be working for you again :)

64bit (x64 and Itanium) OLEDB provider for ODBC (MSDASQL) Download!

If you've ever tried to link a 64bit SQL 2005 server to something like Excel or MySQL you know that it just isn't going to happen without MSDASQL .

Well, it's finally out! Get it right from MS here: http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en

Here's the description from the MS download:
The Microsoft OLE DB Provider for ODBC (MSDASQL) is a technology that allows applications that are built on OLEDB and ADO (which uses OLEDB internally) to access data sources through an ODBC driver. MSDASQL is an OLEDB provider that connects to ODBC, instead of a database. MSDASQL ships with the Windows operating system, and Windows Server 2008 & Windows Vista SP1 are the first Windows releases to include a 64-bit version of the technology.


Enjoy!!