Problem with upgrading

rdobrichrdobrich Posts: 60
edited August 26, 2005 12:18PM in SQL Compare Previous Versions
Hi,

I have SQL compare version 3.1.9.12,
and I have problem when I click for update (new dialog for upgrade).
I shows that there is new upgrade ('new free maintenence releases available '). When I clink View detail it crashed.

Radovan

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Radovan,

    I'm sorry that the new update service is giving you a bit of a hard time. Are there any errors left behind in the Event Log as a result of this crash? Please let us know so we can try to sort out any problems.
  • Hi There is nothing in Event log.

    Only message I can get is message from Detail error botton:

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.ComponentModel.Win32Exception: The system cannot find the file specified
    at System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo)
    at System.Diagnostics.Process.Start()
    at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
    at System.Diagnostics.Process.Start(String fileName)
    at RedGate.Update.ClientForm.ViewDetails_Click(Object sender, EventArgs e)
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
    at System.Windows.Forms.Button.WndProc(Message& m)
    at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/microsoft.net/framework/v1.1.4322/mscorlib.dll
    RedGate.SQLCompare.UI
    Assembly Version: 3.1.9.12
    Win32 Version: 3.1.9.12
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQLCompare.UI.exe
    System.Windows.Forms
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
    System
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
    RedGate.SQLCompare.Engine
    Assembly Version: 3.1.9.12
    Win32 Version: 3.1.9.12
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQLCompare.Engine.DLL
    System.Drawing
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
    RedGate.SQL.Controls
    Assembly Version: 3.3.8.119
    Win32 Version: 3.3.8.119
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQL.Controls.DLL
    RedGate.SQL.Grids
    Assembly Version: 3.3.8.119
    Win32 Version: 3.3.8.119
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQL.Grids.DLL
    ActiproSoftware.TabStripPanel
    Assembly Version: 2.0.205.0
    Win32 Version: 2.0.205.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/ActiproSoftware.TabStripPanel.DLL
    RedGate.SQL.Shared
    Assembly Version: 3.3.8.119
    Win32 Version: 3.3.8.119
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQL.Shared.DLL
    ActiproSoftware.DockableWindow
    Assembly Version: 2.0.205.0
    Win32 Version: 2.0.205.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/ActiproSoftware.DockableWindow.DLL
    DevExpress.XtraBars
    Assembly Version: 2.1.4.0
    Win32 Version: 2.1.4.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/DevExpress.XtraBars.DLL
    DevExpress.XtraEditors
    Assembly Version: 2.0.4.0
    Win32 Version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/DevExpress.XtraEditors.DLL
    DevExpress.Utils
    Assembly Version: 2.0.4.0
    Win32 Version: 2.0.4.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/DevExpress.Utils.DLL
    ActiproSoftware.Wizard
    Assembly Version: 2.0.80.0
    Win32 Version: 2.0.80.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/ActiproSoftware.Wizard.DLL
    RedGate.Licensing.Client
    Assembly Version: 1.2.4.5
    Win32 Version: 1.2.4.5
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.Licensing.Client.DLL
    RedGate.Licensing.Helper
    Assembly Version: 1.2.4.5
    Win32 Version: 1.2.4.5
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.Licensing.Helper.DLL
    System.Xml
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
    RedGate.SQLCompare.BuildInfo
    Assembly Version: 3.1.9.12
    Win32 Version: 3.1.9.12
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.SQLCompare.BuildInfo.DLL
    RedGate.Update.Client
    Assembly Version: 1.0.0.12
    Win32 Version: 1.0.0.12
    CodeBase: file:///C:/Program%20Files/Red%20Gate%20SQL%20Bundle/RedGate.Update.Client.DLL
    System.Web.Services
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system.web.services/1.0.5000.0__b03f5f7f11d50a3a/system.web.services.dll
    System.Web
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system.web/1.0.5000.0__b03f5f7f11d50a3a/system.web.dll
    o8g1t--k
    Assembly Version: 0.0.0.0
    Win32 Version: 1.1.4322.2032
    CodeBase: file:///c:/winnt/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll

    ************** JIT Debugging **************
    To enable just in time (JIT) debugging, the config file for this
    application or machine (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
    <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the machine
    rather than being handled by this dialog.
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    SQL Compare is probably trying to launch RedGate.Update.UpdateCheck.exe. Is this file not in the Red Gate SQL Bundle folder?
  • Yes,
    This file is in the directory.

    Version: 1.0.0.12.

    Radovan
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Radovan,

    This must have to do with Update Service attempting to launch a web browser using a Process.Start() command. This is roughly the same as doing a Start->Run from the start bar and typing the URL.

    Can you please try opening Run from the start bar and type http://www.red-gate.com?

    If this also returns an error, you probably need to go into Windows Explorer and edit the file types so that URLs open with one of your installed browsers.

    Please let me know if you need any more help.
  • Hi,
    when I open run and type http://www.red-gate.exe
    Windows explorer openes and goes to your start page.

    Radovan
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Radovan,

    Which web browser do you have set as the default browser in Windows? Is it Internet Explorer, or a different browser?
  • Hi,
    I only use IE.
    I don't have any browser instaled on my comp.
  • Hi,
    I just think one more thing.
    In my company, I have firewall. Maybe, it uses samo udp port for upgrading.

    Radovan
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    I can't imagine this would be the case. It's just doing basically the same thing as Start->Run http://www.red-gate.com...
  • Can I download trial version, uninstall my version of SQl compare and register it again?
    Maybe, than I can make update?

    Radovan
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Radovan,

    Sure thing. The trial software is identical to the release version.

    Further to the process start problem, I think that if the shell registry key has an incorrect or missing value, the web browser may not start. Can you try running this command, and see what the output is?
    REG QUERY HKEY_CLASSES_ROOT\http\shell\open\command
  • Hi,
    I can't start reg, becouse My win 2000 doesn't recognise command.
    But, with regedit I can read registry.
    In HKEY_CLASSES_ROOT\http\shell\open\command there is
    Value name: (default)
    Value data: "C:\Program Files\Internet Explorer\iexplore.exe" -nohome
  • Hi,
    I just download new trial version and install (without uninstall old version) and now everything works fine.
  • I had the exact same thing happen to me. I downloaded the trial version again and am working fine now. I guess we will have to see what happens with the next version.

    John.
  • This continues to happen to me (last three pt releases) and it takes some searching to rediscover the workaround.

    Is this going to get fixed?

    If not, please consider adding workaround information to the update checker.

    Thanks,
    -- MikeR

    PS. The good news is that this last release (3.41) seems to have fixed all but one problem.
  • Hi

    We have found that there is a problem when using Windows 2000 and passing a url to the browser.

    If you are using Windows 2000 please use the check for updates to see if there is a new version and then download the file from the web site rather than by via the update service.

    We are trying to find a workaround and hope to have one soon.

    Regards
    Dan
    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.