Toad World® Forums

LogReader Powershell commands missing assembly reference error

Hi!

I attempted to run the command:

#run as admin

$lrpath = ‘C:\Program Files (x86)\Dell\Toad for SQL Server Freeware 6.6\Plugins\SqlServer\LogReader’

set-alias install $env:WinDir\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe

install “$lrpath\LogReader.SqlServer.PSSnapIn.dll”

Update-FormatData -appendPath $lrpath\LogReader.SqlServer.Format.ps1xml

Add-PSSnapin LogReader.SqlServer

$logReader = New-QLRSqlReader -Backup -FullBackup ‘\XXXXXXXXXX_FULL_20160124_004541.bak’ `

-LogBackup @( `

‘XXXXXXXXXX_LOG_20160124_010026.trn’ `

)

Get-QLRSqlRecord $logReader | more

$logReader.Close()

… however it errors with the following (missing assemblies):

New-QLRSqlReader : Could not load file or assembly ‘DevExpress.Utils.v14.1, Version=14.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a’ or one of its dependencies. The
system cannot find the file specified.
At line:1 char:14

  • $logReader = New-QLRSqlReader -Backup -FullBackup '\XXXXXXXXXX …
  • CategoryInfo : NotSpecified: (:slight_smile: [New-QLRSqlReader], FileNotFoundException
  • FullyQualifiedErrorId : System.IO.FileNotFoundException,Quest.LogReader.SqlServer.PSSnapIn.Commands.New_QLRSqlReaderCommand

Does anyone know where these dependencies live so I can add them? Specifically DevExpress.Utils and any others it might need?

Thank you very much in advance!

Likely due to using the free version