Global ODBC connection test fails with error 0x80040154

Symptom

When you click the Test button after creating an ODBC connection it fails with the following error code:

0x80040154

Cause

Caused by the Microsoft Data Access objects not being registered.

Resolution

Register the dao350 and dao360 dlls found in C:\Program Files\Common Files\Microsoft Shared\DAO\ with the RegSvr32 utility.