Toad World® Forums

Switching between connections from Connection Manager cause exception


#1

In the SQLserver list in the Connection Manager,

open a connection

do a query

then double click on different SQLserver in Connection Manager

do a query

switch back to the first connection: BANG

switch to the second: BANG

it seems that switching between SQL editor windows also cause same exception
after the same operations.

Lars F.


#2

Hello Lars,

I can’t reproduce this issue on the same environment – W7 64bit, TSS 4.6
Freeware. Is it reproducible every time on your side?

regards,

Alexander


#3

SEE ATTACHMENT
IMAGE.xxx (43 Bytes)


#4

SEE ATTACHMENT
image004.gif


#5

Hi,
I am facing the same problem on my machine, this happens when there are multiple tabs opened connected to different databases and switiching between the tabs causes this exception.

Toad guru’s out ther — need help!!

*** This is the exception ***

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
at Quest.Toad.SqlServer.ActionHandler.DTC.DTCInvoke…ctor()
at Quest.Toad.SqlServer.Trl.DTC.DTCListTrl.get_ImageIndex()
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.SetNodeImage(TreeListNode node, ITrl trl)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.RebuildUI()
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.set_CurrentType(String value)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.SetActiveTrl(ITrl trl)
at Quest.Toad.DatabaseBrowser.ObjectPaletteControl.ConnectionChangedHandler(Object sender, ConnectionEventArgs e)
at Quest.Toad.Notification.ConnectionChangedEventHandler.Invoke(Object sender, ConnectionEventArgs e)
at Quest.Toad.Notification.NotificationManager.ConnectionChanged(Object sender, Connection connection)
at Quest.Toad.ConnectionManager.ConnectionHierarchy.set_CurrentConnection(Connection value)
at Quest.Toad.Util.Global.set_CurrentConnection(Connection value)
at Quest.Toad.Gui.DocumentConnectionFollower.ConnectionChanged(Object sender, EventArgs args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

Rgds

Nams


#6

Hi Nams,
can you please reproduce this issue once again and send me Support Bundle (Help -> Support Bundle) for further investigation? I will see your TSS version, your Servers versions and other related material like OS version etc.

thanks in advance,
Alexander


#7

Hi Alex,
Thanks for responsding…Sending you the details…

Rgds

Nams

Support Bundle for Toad for SQL Server Trial 5.016/11/10 10:04:14 AM System InformationOperating System Microsoft Windows 7 Professional 6.1.7600 x86 Manufacturer: Microsoft Corporation Computer Name: NAMSHITW7X32 Windows Directory: C:\Windows Computer System Computer Manufacturer Name: Hewlett-Packard Computer Model: HP Compaq 8100 Elite CMT PC System Type: X86-based PC Total Physical Memory: 3,661,100 KB Domain: vdi.local User Name: VDI\NamshithH System Processor Manufacturer: GenuineIntel Computer Processor: x64 Family 6 Model 37 Stepping 2 CPU Speed: 3.466 GHz L2 Cache Size: 1 KB System Bios BIOS: Default System BIOS BIOS Version: HPQOEM - 20091216 System Time Zone Time Zone: (UTC) Dublin, Edinburgh, Lisbon, London Logical Memory ConfigurationConnection InformationCurrent Connection: syseas1 (sa), OASIS_CLS SQL Server database Server version 9.0.1399.6 Connected since 16/11/10 10:03:25 AM 0 of 2 connections in pool activeSQL Server Registry Information - 2005 Debugging ConfigurationHKEY_CLASSES_ROOT\CLSID{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} = PSFactoryBuffer HKEY_CLASSES_ROOT\CLSID{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\InprocServer32 ThreadingModel= Both = C:\Program Files\Common Files\Microsoft Shared\SQL Debugging\ssdebugps.dll ( FileVersion:2009.0100.1600.01 ((KJ_RTM).100402-1540 ) InternalName:SSDEBUGPS CompanyName:Microsoft Corporation ) HKEY_CLASSES_ROOT\CLSID{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\ProgID HKEY_CLASSES_ROOT\CLSID{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\Server HKEY_CLASSES_ROOT\Interface{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} = IHostDebugDebuggerInstance HKEY_CLASSES_ROOT\Interface{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods = 4 HKEY_CLASSES_ROOT\Interface{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32 = {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} HKEY_CLASSES_ROOT\Interface{87BC18DC-C8B3-11D5-AE96-00B0D0E93CC1} = IHostDebugServerInstance HKEY_CLASSES_ROOT\Interface{87BC18DC-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods = 5 HKEY_CLASSES_ROOT\Interface{87BC18DC-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32 = {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} HKEY_CLASSES_ROOT\Interface{87BC18DD-C8B3-11D5-AE96-00B0D0E93CC1} = IHostDebugEvent HKEY_CLASSES_ROOT\Interface{87BC18DD-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods = 18 HKEY_CLASSES_ROOT\Interface{87BC18DD-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32 = {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} HKEY_CLASSES_ROOT\Interface{87BC18DE-C8B3-11D5-AE96-00B0D0E93CC1} = IHostDebug HKEY_CLASSES_ROOT\Interface{87BC18DE-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods = 16 HKEY_CLASSES_ROOT\Interface{87BC18DE-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32 = {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} HKEY_CLASSES_ROOT\Interface{87BC18DF-C8B3-11D5-AE96-00B0D0E93CC1} = IHostDebugBinary HKEY_CLASSES_ROOT\Interface{87BC18DF-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods = 6 HKEY_CLASSES_ROOT\Interface{87BC18DF-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32 = {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} HKEY_CLASSES_ROOT\Interface{87BC18E0-C8B3-11D5-AE96-00B0D0E93CC1} = IEnumHostDebugSymbol HKEY_CLASSES_ROOT\Interface{87BC18E0-C8B3-11D5-AE96-00B0D0E93CC1}\NumMethods = 8 HKEY_CLASSES_ROOT\Interface{87BC18E0-C8B3-11D5-AE96-00B0D0E93CC1}\ProxyStubClsid32 = {87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1} @@Version9.0.1399.6 Connection: syscis3 (sa), master SQL Server database Server version 9.0.4035.0 Connected since 15/11/10 05:40:30 PM 0 of 2 connections in pool active Loaded Assemblies {0381adf5-6c16-4c02-b1f0-16a0e0331c3a}, Version=0.0.0.0, Culture=neutral, PublicKeyToken=3e56350693f7355e 9dn_w6q6, Version=5.0.0.554, Culture=neutral, PublicKeyToken=null Accessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\Accessibility\2.0.0.0__b03f5f7f11d50a3a\Accessibility.dll ActiproSoftware.Shared.Net20, Version=1.0.103.0, Culture=neutral, PublicKeyToken=36ff2196ab5654b9 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.Shared.Net20\1.0.103.0__36ff2196ab5654b9\ActiproSoftware.Shared.Net20.dll ActiproSoftware.SyntaxEditor.Net20, Version=4.0.284.0, Culture=neutral, PublicKeyToken=21a821480e210563 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Net20\4.0.284.0__21a821480e210563\ActiproSoftware.SyntaxEditor.Net20.dll ActiproSoftware.UIStudio.Dock.Net20, Version=2.0.109.0, Culture=neutral, PublicKeyToken=be939c973e8cb8a6 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.UIStudio.Dock.Net20\2.0.109.0__be939c973e8cb8a6\ActiproSoftware.UIStudio.Dock.Net20.dll ActiproSoftware.WinUICore.Net20, Version=1.0.103.0, Culture=neutral, PublicKeyToken=1eba893a2bc55de5 C:\Windows\assembly\GAC_MSIL\ActiproSoftware.WinUICore.Net20\1.0.103.0__1eba893a2bc55de5\ActiproSoftware.WinUICore.Net20.dll DevExpress.BonusSkins.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Windows\assembly\GAC_MSIL\DevExpress.BonusSkins.v9.3\9.3.3.0__95fc6c5621878f0a\DevExpress.BonusSkins.v9.3.dll DevExpress.Charts.v9.3.Core, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.Charts.v9.3.Core\9.3.3.0__b88d1754d700e49a\DevExpress.Charts.v9.3.Core.dll DevExpress.Data.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.Data.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.Data.v9.3.dll DevExpress.OfficeSkins.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=95fc6c5621878f0a C:\Windows\assembly\GAC_MSIL\DevExpress.OfficeSkins.v9.3\9.3.3.0__95fc6c5621878f0a\DevExpress.OfficeSkins.v9.3.dll DevExpress.Utils.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.Utils.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.Utils.v9.3.dll DevExpress.XtraBars.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraBars.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraBars.v9.3.dll DevExpress.XtraCharts.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraCharts.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraCharts.v9.3.dll DevExpress.XtraCharts.v9.3.UI, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraCharts.v9.3.UI\9.3.3.0__b88d1754d700e49a\DevExpress.XtraCharts.v9.3.UI.dll DevExpress.XtraEditors.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraEditors.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraEditors.v9.3.dll DevExpress.XtraGrid.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraGrid.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraGrid.v9.3.dll DevExpress.XtraTreeList.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraTreeList.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraTreeList.v9.3.dll DevExpress.XtraVerticalGrid.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\Windows\assembly\GAC_MSIL\DevExpress.XtraVerticalGrid.v9.3\9.3.3.0__b88d1754d700e49a\DevExpress.XtraVerticalGrid.v9.3.dll FastData, Version=3.0.0.554, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\FastData.dll FlexCel, Version=5.1.0.0, Culture=neutral, PublicKeyToken=cb8f6080e6d5a4d6 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\FlexCel.dll ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\ICSharpCode.SharpZipLib.dll ManagedQP5, Version=5.2.5.554, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\managedqp5.dll MLangLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\MLangLib.dll mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll msvcm90, Version=9.0.30729.4926, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4926_none_508ed732bcbc0e5a\msvcm90.dll PresentationCore, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\Windows\assembly\GAC_32\PresentationCore\3.0.0.0__31bf3856ad364e35\PresentationCore.dll Quest.Compare.General.Sys, Version=4.6.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Quest.Compare.General.Sys.dll Quest.Compare.General.SysInterfaces, Version=4.6.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Quest.Compare.General.SysInterfaces.dll Quest.DatabaseReader.SqlServer.PL, Version=1.3.2.4, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\LogReader\Quest.DatabaseReader.SqlServer.PL.dll Quest.DataCompare.PL, Version=3.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\Data Compare\Quest.DataCompare.PL.dll Quest.LogReader.Engine, Version=1.3.2.4, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\LogReader\Quest.LogReader.Engine.dll Quest.PersistentCache, Version=3.0.0.554, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Quest.PersistentCache.dll Quest.Schema.Common, Version=3.1.0.101, Culture=neutral, PublicKeyToken=f1f355dc0dfad359 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.dll Quest.Schema.Common.Interfaces, Version=3.1.0.101, Culture=neutral, PublicKeyToken=f1f355dc0dfad359 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.Interfaces.dll Quest.Schema.MSSQL.ComparePlugin, Version=3.1.0.101, Culture=neutral, PublicKeyToken=null C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.ComparePlugin.dll Quest.Schema.MSSQL.Interfaces, Version=3.1.0.102, Culture=neutral, PublicKeyToken=f1f355dc0dfad359 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.Interfaces.dll Quest.Schema.MSSQL.Snapshot, Version=3.1.0.102, Culture=neutral, PublicKeyToken=f1f355dc0dfad359 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.Snapshot.dll Quest.Shared, Version=3.1.0.103, Culture=neutral, PublicKeyToken=f1f355dc0dfad359 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\Compare\Schema\Quest.Shared.dll Quest.Tech, Version=3.1.0.0, Culture=neutral, PublicKeyToken=c5ecf5e3fe1a5c16 C:\Windows\assembly\GAC_MSIL\Quest.Tech\3.1.0.0__c5ecf5e3fe1a5c16\Quest.Tech.dll Quest.Toad.Interop.AxSHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Quest.Toad.Interop.AxSHDocVw.dll Quest.UI.Controls, Version=2.1.0.278, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\LogReader\Quest.UI.Controls.dll Quest.VersionControl, Version=1.1.0.554, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Quest.VersionControl.dll Quest.Windows.UI.ConsoleControls, Version=2.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\LogReader\Quest.Windows.UI.ConsoleControls.dll Quest.Windows.UI.Wizard, Version=3.0.0.5, Culture=neutral, PublicKeyToken=fe6aa00b36e17863 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\ServiceBroker\Quest.Windows.UI.Wizard.dll Quest.Windows.UI.Wizard.Controls, Version=2.0.4.21, Culture=neutral, PublicKeyToken=d63fc677c65c72b2 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\ServiceBroker\Quest.Windows.UI.Wizard.Controls.dll QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\QuestElevation.exe QuestLogReaderSqlServerWrapper, Version=1.3.2.4, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\Plugins\SqlServer\LogReader\QuestLogReaderSqlServerWrapper.dll SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=c862883b2ae69822 C:\Program Files\Quest Software\Toad for SQL Server Trial 5.0\SHDocVw.dll System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
ToadSupportBundleToad for SQL Server.zip (90.3 KB)


#8

Hi Nams,
I’ve tried to reproduce your issue on my environment that is close to your and of cause on some others, but without success. I mean switching between open editors for different connections works fine. I expirienced some difficulties while running long queries but it is another kind of problems - I don’t see any exception error.

We do remember several reports regarding similar issue on switching connection, so we are trying to keep an eye on this. Please report in any other issues or if you have some addition details regarding this particular issue.

thanks, Alexander.


#9

I remember I saw it couple of times in previous versions of ToadSS. Then the
problem didn’t reveal itself for a while… Now we see it was never
gone actually. I’ll try to see if I can reproduce it again.

Thanks for the reporting,

Igor.