Enabling verbose logging on the DLO console displays the following error:
dloconsoleu.exe 2276: > adoutil.h( 70 ) Connection error: 80040E14( 00004556 ) : Could not load the DLL XPDLOShareu.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).
64 bit version of XPDLOShareu.dll needs to be copied to Binn folder in the installation directory for SQL on the 64 bit server. For eg:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\XPDLOShareu.dll
Extract the 64 bit version of XPDLOShareu.dll _64.XXXX from the database.cab file in the installation media for DLO (usually a zip file, if downloaded).
Rename this file to XPDLOShareu.dll.
This file needs to be placed in the Binn folder under the SQL installation directory on the SQL server.
For e.g: copy the extracted XPDLOShareu.dll file to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn . If the file exists at this location, rename the existing file to XPDLOShareu.OLD and then copy the file over to the Binn directory.