-
Title
Get "Could not load the DLL xp_QuestLogReader.dll..." error reading transaction log -
Description
When trying to read a transaction log for one of our SQL Server databases, I get the following messages.
"Could not load the DLL xp_QuestLogReader.dll, or one of the DLLs it references."
-
Cause
Installation corrupt
-
Resolution
1. Locate xp_QuestLogReader.dll on the host where the application is installed.
2. Copy xp_QuestLogReader.dll to the \BIN folder of the SQL Server instance where you want to install Log Reader Server Components
Tip: You can use the EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\Setup', N'SQLPath' command to define your server location.If the SQL Server is 64 bit please use the correct x64 or ia64 dll.
You can use xp_QuestLogReader.dll for x86; xp_QuestLogReader_x64.dll is for x64; xp_QuestLogReader_ia64.dll is for Itanium.
After placing the correct 64bit type dll (xp_QuestLogReader_x64.dll ; xp_QuestLogReader_ia64.dll) into the BIN Directory, please rename the DLL back to its original name xp_QuestLogReader.dll
3. Run the following commands on the SQL Server instance:
EXEC sp_addextendedproc 'xp_qlr_version', 'xp_QuestLogReader.dll'
EXEC sp_addextendedproc 'xp_qlr_logfile', 'xp_QuestLogReader.dll'
EXEC sp_addextendedproc 'xp_qlr_loginfo', 'xp_QuestLogReader.dll'
EXEC sp_addextendedproc 'xp_qlr_logread', 'xp_QuestLogReader.dll'