Command Line Error

godot

I am using the trial version of SQL Compare to test creation of a snapshot on a remote database system, but it is generating an error. I need to test this process before purchasing because many of our databases do not allow direct external access.

DotNet 1.1 is installed on the PC I am running the snapshot from over PCAnywhere. The database is SQL Server 2000.

Here is my batch file text:
===========================================
SQLCompare /Server1:Database1 /makesnapshot:DB1.snp
===========================================

The error is from the Common Language Runtime Debugging Services.
"Application has generated an exception that could not be handled."
Process id=0xadc (2780), Thread id=0x534 (1332)


What am I doing wrong?

Brian Donahue

Hello,

The error message isn't incredibly revealing, but it usually indicates a problem with the Framework. What is the full version number you've installed? 1.1.4322.510 is a version that keeps popping up and causing us problems. It was a beta of Framework 1.1. The first full version of 1.1 was 1.1.4322.573. If you do not have this version, then please get it from Microsoft.

Thanks!

godot

After copying a number of RedGate and SQLCompare DLLs to the remote system and having the system administrator update DotNet (to 2.0), here is what I get just trying to access the help...

J:\MCS>sqlcompare /help

Unhandled Exception: System.Security.SecurityException: Security error.
at RedGate.SQLCompare.CommandLine.Startup._1(String[] )

The granted set of the failing assembly was:
<PermissionSet class="System.Security.PermissionSet"
version="1">
<IPermission class="System.Security.Permissions.EnvironmentPermission, mscorl
ib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="USERNAME"/>
<IPermission class="System.Security.Permissions.FileDialogPermission, mscorli
b, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, V
ersion=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Read="J:\MCS\"
PathDiscovery="J:\MCS\"/>
<IPermission class="System.Security.Permissions.IsolatedStorageFilePermission
, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
"
version="1"
Allowed="AssemblyIsolationByUser"
UserQuota="9223372036854775807"
Expiry="9223372036854775807"
Permanent="True"/>
<IPermission class="System.Security.Permissions.ReflectionPermission, mscorli
b, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="ReflectionEmit"/>
<IPermission class="System.Security.Permissions.SecurityPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Flags="Assertion, Execution, BindingRedirects"/>
<IPermission class="System.Security.Permissions.UIPermission, mscorlib, Versi
on=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Net.DnsPermission, System, Version=1.0.5000.0, Cul
ture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Unrestricted="true"/>
<IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawin
g, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
version="1"
Level="DefaultPrinting"/>
<IPermission class="System.Diagnostics.EventLogPermission, System, Version=1.
0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1">
<Machine name="."
access="Instrument"/>
</IPermission>
<IPermission class="System.Security.Permissions.StrongNameIdentityPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"
PublicKeyBlob="0024000004800000940000000602000000240000525341310
0040000010001008FC10F454406BF85568F958675567383EB344EF516BEC3937AAD9239B15EDF1EB
663E2501CE211AB47FB6C26554697B487E8CDA6B2D662B42146417D62AA9C74C4719BC5910DB2659
584ADC4F07F0687744B038085B76CC6336A7108738CCFD0AABE44760EC94C8DFD29009FC2DEF7845
5CE1920A2A5696D108734386CE04AD9"
Name="SQLCompare"
AssemblyVersion="4.1.0.77"/>
<IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorl
ib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Url="file://J:/MCS/SQLCompare.exe"/>
<IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscor
lib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
Zone="Intranet"/>
</PermissionSet>


J:\MCS>

Brian Donahue

Thanks for the stack trace. Now it's pretty clear that you're trying to run the program through a mapped drive or network share, which .NET doesn't allow. Maybe you can get this to work by using the .NET Framework 1.1 Wizards in your control panel->administrative tools? There is a wizard called 'trust an assembly' and you should be able to enter the path to the assembly and at that point you should not get the security exception any more.