Moving a Desktop and Laptop Option (DLO) database to a 64 bit SQL server fails to load DLO or its components. Error: Reason: 193 (XPDLOShareu.dll is not a valid Win32 application.).

Problem

When a DLO database is moved to a SQL instance installed on a 64 bit version of Windows operating system, the Restore window may not display any items.

Browsing the items may cause an error:

Cannot search for files to restore. Please refresh the list of computers

Error Message

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.).

Cause

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

Solution

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.