Command Line Error

godotgodot Posts: 8
edited February 28, 2006 5:15AM in SQL Compare Previous Versions
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?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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!
  • 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 DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
Sign In or Register to comment.