SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in .net 4.0 support ?      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic .net 4.0 support ? Author Message 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom .net 4.0 support ? Windows 7 .NET Framework 4 Quest Software Toad for SQL Server 5.8 - 6.1 (and other software based on 4.* .net) SQL Assistant 6.5.276 Ctrl+Shift+F5 result: http://oi39.tinypic.com/108ibds.jpg Sun Jan 12, 2014 11:43 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 What do you have in the registry under [HKEY_CLASSES_ROOT\CLSID\{754CF073-A5EE-4E97-880D-2D88D8D514BE}\InprocServer32] key ? Mon Jan 13, 2014 8:45 am 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom Quote: [HKEY_CLASSES_ROOT\CLSID\{754CF073-A5EE-4E97-880D-2D88D8D514BE}] @="SqlAssist.Ase.Editor" "AppID"="{754CF073-A5EE-4E97-880D-2D88D8D514BE}" [HKEY_CLASSES_ROOT\CLSID\{754CF073-A5EE-4E97-880D-2D88D8D514BE}\InprocServer32] @="mscoree.dll" "CodeBase"="C:\\Program Files\\SQL Assistant 6\\data\\SqlAssist.Ase4.dll" "Assembly"="SqlAssist.Ase, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" "Class"="SqlAssist.Ase.Editor" "RuntimeVersion"="v4.0.30128" "ThreadingModel"="Both" [HKEY_CLASSES_ROOT\CLSID\{754CF073-A5EE-4E97-880D-2D88D8D514BE}\ProgId] @="SqlAssist.Ase.Editor" Mon Jan 13, 2014 9:44 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Your registry settings seem to be correct. They point to SqlAssist.Ase4.dll which is compiled for .Net 4 framework. Please try starting SQL Assistant in "Run as Administrator" and then try opening Toad again. Open new editor within Toad and then type SELECt, see if SQL Assistant's prompt will popup. By the way, do not use Ctrl+Shift+F5 with Toad, it won't do any good in that target. The "Unsupported window class" is expected in .Net4 target types. They all require specific add-ons. Mon Jan 13, 2014 10:06 pm 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom SysOp wrote: Please try starting SQL Assistant in "Run as Administrator" and then try opening Toad again. Open new editor within Toad and then type SELECt, see if SQL Assistant's prompt will popup. it doesn't work And working without any problem with Toad 5.7 Mon Jan 13, 2014 11:14 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Please restart SQL Assistant with logging enabled SQLAssistant /SA:TraceLogLevel:9 then start your Toad 6.1 and open new editor window. Please copy and paste here last several lines from %APPDATA%\SQL Assistant\6.5\SQLAssist.log file related to Toad activities Tue Jan 14, 2014 1:18 am 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom 6.0 >> 5.8 >> 5.7 Code: ====================================================================== 14.01.2014 15:31:09   SqlAssist.exe   SA=6.5.276; Exe=C:\Program Files\SQL Assistant 6\SqlAssist.exe; Cmd="C:\Program Files\SQL Assistant 6\SqlAssist.exe" /SA:TraceLogLevel:9; LogLvl=9; MsgLvl=0 14.01.2014 15:31:09   SqlAssist.exe   Server: CheckInstallation 14.01.2014 15:31:09   SqlAssist.exe   Server: Create 14.01.2014 15:31:09   SqlAssist.exe   SA=6.5.276; Exe=C:\Program Files\SQL Assistant 6\SqlAssist.exe; Cmd="C:\Program Files\SQL Assistant 6\SqlAssist.exe" /SA:TraceLogLevel:9; LogLvl=9; MsgLvl=0 14.01.2014 15:31:09   SqlAssist.exe   Client: Attach 14.01.2014 15:31:23   Explorer.EXE   SA=6.5.276; Exe=C:\Windows\Explorer.EXE; Cmd=C:\Windows\Explorer.EXE; LogLvl=9; MsgLvl=0 14.01.2014 15:31:23   Explorer.EXE   Client: Attach 14.01.2014 15:31:23   toad.exe   SA=6.5.276; Exe=C:\Program Files\Quest Software\Toad for SQL Server 6.0\toad.exe; Cmd="C:\Program Files\Quest Software\Toad for SQL Server 6.0\toad.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:31:23   toad.exe   Client: Attach 14.01.2014 15:31:23   toad.exe   Client: Create 14.01.2014 15:31:24   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "-2000575431-704628765898312230-1812889940-59253342-1619985908-667395522-974335699"; LogLvl=9; MsgLvl=0 14.01.2014 15:31:24   conhost.exe   Client: Attach 14.01.2014 15:31:24   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "-1204620033-2146920977349782570102392632-133984373-1079706967-219312441-1654362338"; LogLvl=9; MsgLvl=0 14.01.2014 15:31:24   conhost.exe   Client: Attach 14.01.2014 15:31:29   toad.exe   Client: CreateTargetList 14.01.2014 15:31:29   toad.exe   SA=6.5.276; Exe=C:\Program Files\Quest Software\Toad for SQL Server 6.0\toad.exe; Cmd="C:\Program Files\Quest Software\Toad for SQL Server 6.0\toad.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:31:29   toad.exe   Prefs: Attach 14.01.2014 15:31:29   toad.exe   TargetList: SetSuspend=0 14.01.2014 15:31:29   toad.exe   TargetList: Create: Rok=1 14.01.2014 15:31:29   toad.exe   TargetList: SetSuspend=0 14.01.2014 15:31:29   toad.exe   TargetList: EnumWnd (class=WindowsForms%.Window.%) 14.01.2014 15:31:40   Miranda32.exe   SA=6.5.276; Exe=C:\Program Files\miranda ng\Miranda32.exe; Cmd="C:\Program Files\miranda ng\Miranda32.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:31:40   Miranda32.exe   Client: Attach 14.01.2014 15:31:40   toad.exe   Client: CloseQuery 14.01.2014 15:31:40   toad.exe   TargetList: CloseQuery 1 14.01.2014 15:31:41   toad.exe   Prefs: Detach 14.01.2014 15:31:41   toad.exe   TargetList: Destroy 14.01.2014 15:31:41   toad.exe   TargetList: Save Toad for SQL Server 14.01.2014 15:31:41   toad.exe   Client: Destroy 14.01.2014 15:31:41   toad.exe   Client: Detach 14.01.2014 15:31:44   toad.exe   SA=6.5.276; Exe=C:\Program Files\Quest Software\Toad for SQL Server 5.8\toad.exe; Cmd="C:\Program Files\Quest Software\Toad for SQL Server 5.8\toad.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:31:44   toad.exe   Client: Attach 14.01.2014 15:31:44   toad.exe   Client: Create 14.01.2014 15:31:46   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "1835723545145043844515056364191186821839-1199938086-5630387332065958514-979252189"; LogLvl=9; MsgLvl=0 14.01.2014 15:31:46   conhost.exe   Client: Attach 14.01.2014 15:31:46   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "1948753376-10662956652041103903143325816-425384128-17725487231160151205680795887"; LogLvl=9; MsgLvl=0 14.01.2014 15:31:46   conhost.exe   Client: Attach 14.01.2014 15:31:56   toad.exe   Client: CreateTargetList 14.01.2014 15:31:56   toad.exe   SA=6.5.276; Exe=C:\Program Files\Quest Software\Toad for SQL Server 5.8\toad.exe; Cmd="C:\Program Files\Quest Software\Toad for SQL Server 5.8\toad.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:31:56   toad.exe   Prefs: Attach 14.01.2014 15:31:56   toad.exe   TargetList: SetSuspend=0 14.01.2014 15:31:56   toad.exe   TargetList: Create: Rok=1 14.01.2014 15:31:56   toad.exe   TargetList: SetSuspend=0 14.01.2014 15:31:56   toad.exe   TargetList: EnumWnd (class=WindowsForms%.Window.%) 14.01.2014 15:31:58   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "-1802499813735480721363570470-19523883691734626459-20240301551808520506407553820"; LogLvl=9; MsgLvl=0 14.01.2014 15:31:58   conhost.exe   Client: Attach 14.01.2014 15:32:15   toad.exe   Client: CloseQuery 14.01.2014 15:32:15   toad.exe   TargetList: CloseQuery 1 14.01.2014 15:32:15   toad.exe   Prefs: Detach 14.01.2014 15:32:15   toad.exe   TargetList: Destroy 14.01.2014 15:32:15   toad.exe   TargetList: Save Toad for SQL Server 14.01.2014 15:32:16   toad.exe   Client: Destroy 14.01.2014 15:32:16   toad.exe   Client: Detach 14.01.2014 15:32:20   toad.exe   SA=6.5.276; Exe=C:\Program Files\Quest Software\Toad for SQL Server 5.7\toad.exe; Cmd="C:\Program Files\Quest Software\Toad for SQL Server 5.7\toad.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:32:20   toad.exe   Client: Attach 14.01.2014 15:32:20   toad.exe   Client: Create 14.01.2014 15:32:24   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "481911255-116750360-975720023-9487362881049809158-1965062309540913389233560049"; LogLvl=9; MsgLvl=0 14.01.2014 15:32:24   conhost.exe   Client: Attach 14.01.2014 15:32:25   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "944851377177344874-248295432-10374717522111482862025554472-872029871610493332"; LogLvl=9; MsgLvl=0 14.01.2014 15:32:25   conhost.exe   Client: Attach 14.01.2014 15:32:44   toad.exe   Client: CreateTargetList 14.01.2014 15:32:44   toad.exe   SA=6.5.276; Exe=C:\Program Files\Quest Software\Toad for SQL Server 5.7\toad.exe; Cmd="C:\Program Files\Quest Software\Toad for SQL Server 5.7\toad.exe" ; LogLvl=9; MsgLvl=0 14.01.2014 15:32:44   toad.exe   Prefs: Attach 14.01.2014 15:32:44   toad.exe   TargetList: SetSuspend=0 14.01.2014 15:32:44   toad.exe   TargetList: Create: Rok=1 14.01.2014 15:32:44   toad.exe   TargetList: SetSuspend=0 14.01.2014 15:32:44   toad.exe   TargetList: EnumWnd (class=WindowsForms%.Window.%) 14.01.2014 15:32:45   toad.exe   Target: Create: Pref=Toad for SQL Server 14.01.2014 15:32:45   toad.exe   Target: Create: Code=7 14.01.2014 15:32:45   toad.exe   PopupInitBars: result=1 14.01.2014 15:32:45   toad.exe   Target: Create: Pref=Toad for SQL Server 14.01.2014 15:32:45   toad.exe   Target: Create: Code=7 14.01.2014 15:32:45   toad.exe   Target: Create: Pref=Toad for SQL Server 14.01.2014 15:32:45   toad.exe   Target: Create: Code=7 14.01.2014 15:32:45   toad.exe   Target: Create: Pref=Toad for SQL Server 14.01.2014 15:32:45   toad.exe   Target: Create: Code=7 14.01.2014 15:32:45   toad.exe   Target: Create: Pref=Toad for SQL Server 14.01.2014 15:32:45   toad.exe   Target: Create: Code=7 14.01.2014 15:32:45   toad.exe   Target: Create: Pref=Toad for SQL Server 14.01.2014 15:32:45   toad.exe   Target: Create: Code=7 14.01.2014 15:32:48   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "-1341767777-1276121151744928743483795742-325362671-1329532604-1951287215478948115"; LogLvl=9; MsgLvl=0 14.01.2014 15:32:48   conhost.exe   Client: Attach 14.01.2014 15:32:49   conhost.exe   SA=6.5.276; Exe=C:\Windows\system32\conhost.exe; Cmd=\??\C:\Windows\system32\conhost.exe "14784606721757542277370168542-1528352532-796356472-1492549590-416510741-347746162"; LogLvl=9; MsgLvl=0 14.01.2014 15:32:49   conhost.exe   Client: Attach 14.01.2014 15:32:58   toad.exe   fmConnect: Create 14.01.2014 15:32:58   toad.exe   fmConnect: OK 14.01.2014 15:32:58   toad.exe   fmConnect: Release 14.01.2014 15:32:59   toad.exe   fmConnect: Destroy 14.01.2014 15:33:05   SqlAssist.exe   Server: ShowPopup 14.01.2014 15:33:06   toad.exe   Target: Destroy 14.01.2014 15:33:06   toad.exe   Target: Destroy 14.01.2014 15:33:06   toad.exe   Target: Destroy 14.01.2014 15:33:06   toad.exe   Target: Destroy 14.01.2014 15:33:06   toad.exe   Target: Destroy 14.01.2014 15:33:06   toad.exe   Target: Destroy 14.01.2014 15:33:06   toad.exe   Client: CloseQuery 14.01.2014 15:33:06   toad.exe   TargetList: CloseQuery 1 14.01.2014 15:33:06   toad.exe   Prefs: Detach 14.01.2014 15:33:06   toad.exe   TargetList: Destroy 14.01.2014 15:33:06   toad.exe   TargetList: Save Toad for SQL Server 14.01.2014 15:33:06   toad.exe   Client: Destroy 14.01.2014 15:33:06   toad.exe   Client: Detach 14.01.2014 15:33:07   SqlAssist.exe   Server: Close 14.01.2014 15:33:07   SqlAssist.exe   Server: Destroy 14.01.2014 15:33:07   Explorer.EXE   Client: Detach 14.01.2014 15:33:07   SqlAssist.exe   Server: Exit 14.01.2014 15:33:07   Miranda32.exe   Client: Detach Tue Jan 14, 2014 4:35 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Thank you. the log is very helpful. Couple more things that I need you to check Please use Microsoft Process Explorer utility to check which version of ActiPro editor is loaded by Toad. If you don't already have Process Explorer installed, you can get it here http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx , it's free. 1. Start Toad 6.1. Open edit tab. Make sure no other versions of Toad are running. 2. Start Process Explorer, use Find -> Find Handle or DLL... command to search for ActiproSoftware.SyntaxEditor 3. Let us know the full name of the found assembly send us name of the found assembly, it should be something like ActiproSoftware.SyntaxEditor.*.dll, we need to know the version part and the exact path 4. Repeat search, but this time search for SqlAssist.Ase 5. Let us know if you find SqlAssist.Ase.dll or SqlAssist.Ase4.dll Tue Jan 14, 2014 11:03 pm 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom 1. C:\Windows\assembly\NativeImages_v4.0.30319_32\ActiproSoftware.Syn#\d1b8d53fb695f45bbcd069ae514d9a23\ActiproSoftware.SyntaxEditor.WinForms.ni.dll (ver. 12.1.302.0) 2. SqlAssist.Ase4.dll Tue Jan 14, 2014 11:34 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Thank you. I don't know if that version of Actipro editor is supported. Let me circle back with the development team. Wed Jan 15, 2014 12:05 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 I was told that your version is supported. This means there could be an issue with your SQL Assistant settings. 1. Please open %AAPDATA%\SQL Assistant\6.5\SqlAssist.sas file in notepad. 2. Search for word Toad. It should appear in several Targets sections. I need to see all these targets sections in order to figure out which settings are incorrect. Please copy here the content of all found target settings. 3. Save a copy of your %AAPDATA%\SQL Assistant\6.5\SqlAssist.sas file. 4. Open SQL Assistant's Options dialog. Click Import/Export button and import factory default settings. 5. Try starting toad 6.5 again and check if it works now. Wed Jan 15, 2014 9:13 am 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom Quote: [targets.19] enabled=1 caption=Toad for SQL Server exeName=toad.exe exeTitle=Toad for SQL Server% clsName=WindowsForms%.Window.% dcType=2 integr=2 integrTop=0 spell_lang=0904 hotTrack=1 jumpBrack=2 hiliBrack=FFFF hiliNames=DDFFDD hiliInsVal=FFE0E0 selKey=0 timeout=60 ctxHint=5 synCheck=0 synBar=1 autoSel=1 smartUndo=1 smartHome=1 varHint=1 tabReplace=0 tabSize=4 handleExc=0 sqlRef=9 assist=SQL Server rules=T-SQL Default Style snips=T-SQL Snippets rfRules=SQL Server Refactoring autoConn=(local) (ODBC) scsPrj= hotAssist=00 hotRefer=00 hotStruct=00 hotBird=00 hotExplorer=00 hotDDL=00 hotTable=00 hotExport=00 hotExec=00 hotExecOn=00 hotSynCheck=00 hotSpell=00 hotFormat=00 hotDiff=00 hotBrackets=00 hotComment=00 hotComment2=00 hotUncomment=00 hotBmAdd=00 hotBmJump=00 hotShowDep=00 hotSelStmt=00 hotExeSelStmt=00 hotSearchWeb=00 hotExecHist=00 hotSearchCode=00 hotRecentDoc=00 hotCloseAll=00 hotTarget=00 statist.active=1 statist.user=67733 statist.sa=2100417 statist.min=4283 panHeight=1201D600D600D600F2009901 pinOrder=00 bmFlags=FFFFFFFF exportFmt=yyyyMMddHH:mm:ssCHAR(%)||YNN1000YC:\Users\adm.skynet\Documents\YY tmpAuto=0 snipChar=0 fileOpen=0 commMeth=0 execKey=46 storeStates=15 maxHistTime=180 docMngAct=1 pmtRestore=2 docFileMask= keepUnsaved=1 restoreLast=1 Default settings doesn't work too (3 tested computers, W7sp1) Wed Jan 15, 2014 10:06 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Please make 2 small changes in the registry as indicated by text in red below [HKEY_CLASSES_ROOT\CLSID\{754CF073-A5EE-4E97-880D-2D88D8D514BE}\InprocServer32] "Assembly"="SqlAssist.Ase4, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" [HKEY_CLASSES_ROOT\CLSID\{754CF073-A5ED-4E97-880D-2D88D8D514BE}\InprocServer32] "Assembly"="SqlAssist.Ase4, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" Hope this does the trick for you. Thu Jan 16, 2014 1:25 am 13th Joined: 12 Jan 2014 Posts: 27 Country: United Kingdom problem is gone. thank you for help! Thu Jan 16, 2014 2:28 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.