SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
.net 4.0 support ?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
.net 4.0 support ?
Author Message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post .net 4.0 support ? Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post Reply with quote
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=yyyyMMdd HH:mm:ss CHAR(%) || Y N N 1000 Y C:\Users\adm.skynet\Documents\ Y Y
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
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 View user's profile Send private message
13th



Joined: 12 Jan 2014
Posts: 18
Country: United Kingdom

Post Reply with quote
problem is gone. thank you for help!
Thu Jan 16, 2014 2:28 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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.