Sql Compare error on startup

SeanX

I get the following error when starting Sql Compare 5.3

---

RedGate.SQLCompare.UI.exe - Common Language Runtime Debugging Services

---

Application has generated an exception that could not be handled.

Process id=0x1498 (5272), Thread id=0xd64 (3428).

Click OK to terminate the application.
Click CANCEL to debug the application.

---

OK Cancel

---

I am using Vista. I have the dev express components for delphi installed, but I can only find one copy of the DevExpress.xxx 6.3 dlls on the computer.

I have tried uninstalling/reinstalling without any joy.


Sean

JonathanWatts

Hi Sean,

Can I ask which version of .NET you have installed? We have been encountering problems with DevExpress when .NET 1.1 is not installed.

See this post for more details: http://www.red-gate.com/messageboard/vi ... 5517#15517

Regards,

Jonathan

SeanX

1.1 and 2.0

Tom Harris

Hi there,

would it be possible for you to capture a stack trace of the crash by hitting debug? I strongly suspect a problem with some 3rd party components, but we can't tell for sure without more details.

Many thanks,

Tom Harris

Red Gate Software

SeanX

When I start the debugger, it gives a second exception:

An unhandled exception of type 'System.TypeInitializationException' occurred in RedGate.SQLCompare.UI.exe

Additional information: The type initializer for "RedGate.SQL.Shared.SQLServerInstances" threw an exception.

Stack trace is as follows:

Address _111._1

00000000 push edi
00000001 push esi
00000002 call dword ptr ds:[003B56F0h]
00000008 mov ecx,eax
0000000a mov edx,1
0000000f mov eax,dword ptr [ecx]
00000011 call dword ptr [eax+7Ch]
00000014 call dword ptr ds:[003B56F0h]
0000001a mov ecx,eax
0000001c xor edx,edx
0000001e mov eax,dword ptr [ecx]
00000020 call dword ptr [eax+00000090h]
00000026 mov ecx,3B5C3Ch
0000002b call 719F22AB
00000030 mov esi,eax
00000032 mov ecx,esi
00000034 call dword ptr ds:[003B61E0h]
0000003a mov ecx,esi
0000003c cmp dword ptr [ecx],ecx
0000003e call dword ptr ds:[7B9DEDA4h]
00000044 mov ecx,esi
00000046 cmp dword ptr [ecx],ecx
00000048 call dword ptr ds:[003B61F8h]
0000004e call dword ptr ds:[003B64E8h]
00000054 mov edi,eax
00000056 call dword ptr ds:[003B7B74h]
>>> 0000005c mov ecx,esi <<<
0000005e cmp dword ptr [ecx],ecx
00000060 call dword ptr ds:[7B9DEC64h]
00000066 mov ecx,3B7C10h
0000006b call F8BE1FC0
00000070 mov ecx,eax
00000072 call dword ptr ds:[7B9E5AF8h]
00000078 mov ecx,edi
0000007a call dword ptr ds:[7B9E5B64h]
00000080 pop esi
00000081 pop edi
00000082 ret

SeanX

I have reinstalled .net 1.1 but that has not fixed the problem.

Sean

SeanX

Any one there?

Tom Harris

Hi,

we are investigatin why the code that retrieves the list of available SQL Servers might be throwing an exception. This is not a bug that we have encountered before. Please bear with us as we try to get to the bottom of the problem.

Many thanks,

Tom Harris

Red Gate Software

Tom Harris

Hi,

could you try out the SQL Compare 6 beta and see of the same problem occurs? SQL Compare 6 is a .NET 2.0 build and may well not exhibit the same phenomena.

Details at http://www.red-gate.com/MessageBoard/viewforum.php?f=65

Thanks,

Tom

SeanX

Tom Harris wrote:

Hi,

could you try out the SQL Compare 6 beta and see of the same problem occurs? SQL Compare 6 is a .NET 2.0 build and may well not exhibit the same phenomena.
Tom

That works.

Thanks

Sean

Nick Warren

Sean - I'm not sure whether using the v6 beta is a valid solution for you, but if not, please can you log a call with our support desk - support@red-gate.com, and someone will look in to what's possible with 5.3.

Thanks, Nick

SeanX

Beta 6 is fine for now.

Sean

shadowbob

I am receiving the same problem, even after uninstalling/reinstalling. I am also using Vista. Vista contains .Net 2.0 and 3.0 built in to the operating system, and I have additionally installed 1.1. The interesting thing is, the software worked for months and months before mysteriously stopping. I can't correlate it with anything I have done to the system, either.

I am going to try 6.0 beta, and as long as the beta doesn't corrupt my databases, that will suffice for me. However, it would be worth looking into the problem.

JonathanWatts

shadowbob,

Can let us know if the beta solves this issue. We are fairly sure that it should, but would like to know just incase.

Thanks,

Jonathan

shadowbob

Jonathan,

6.0 beta definitely solved the issue. My only problem now is, the beta has expired! And since 5 doesn't work, I've hit a wall. I need a working version of this product!

JonathanWatts

Shadowbob,

Sorry about this, we had hoped that there would be a bit over lap between the beta and final release. However, the final testing of SQL Compare 6 has ran on a bit longer. It is nearly complete and we should have the final version out shortly.

Once again sorry about the delay,

Regards,

Jonathan

Daniel Handley

can you please log a call with our support desk as well - support@red-gate.com - so that we can help you directly with this issue.

hemantmcse

Remove MSXML and install MSXML once again