SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
7.1.246 and Toad for SQL Server 6.5
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
7.1.246 and Toad for SQL Server 6.5
Author Message
13th



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

Post 7.1.246 and Toad for SQL Server 6.5 Reply with quote
7.1.246 and Toad for SQL Server 6.5 causing error "C:\Program files (x86)\Dell\Toad for SQL Server 6.5\toad.exe failed to load SqlAssist.Dex4.dll"
Thu Mar 26, 2015 1:18 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Where do you see that error?
Thu Mar 26, 2015 2:24 pm View user's profile Send private message
13th



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

Post Reply with quote
on openning new sql editor tab
Thu Mar 26, 2015 3:01 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Two more questions, what is the full toad version number including build? and do you get this error if you start Toad in Run as Administrator mode?
Sat Mar 28, 2015 9:44 am View user's profile Send private message
13th



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

Post Reply with quote
Toad ver. 6.5.0.3001
Run as Administrator mode = same error
Sat Mar 28, 2015 2:16 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Thank you. If I get it correctly, this is the latest Toad for SQL SErver version available and something may have changed in that versions causing the issue. I created a new ticket in our internal tracking system and asked our development team to try to reproduce this issue and figure out what's causing it.
Mon Mar 30, 2015 9:43 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
We've found that the issue is caused by changes in the latest Toad 6.5.xx builds which is the root cause of the issue with SQL Assistant integration. We will have a compatibility fix provided in SQL Assistant version 7.2, which is going to be released in a few weeks.
Fri Apr 17, 2015 9:28 am View user's profile Send private message
13th



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

Post Reply with quote
thnx! will be waiting.. By the way, toad 6.1 having same problem with sa 7.*
Sun Apr 19, 2015 12:44 pm View user's profile Send private message
13th



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

Post Reply with quote
SQL Assistant 7.2.328
SysOp wrote:
13. Compatibility changes for latest Toad versions.

Mon May 04, 2015 10:49 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
It looks like it's trying to load incorrect .NET framework version or something else similar.
Do you see SQLAssist.log file in %APPDATA%\SQL Assistant\7.2? If you got it, are there any errors recorded with today's date?

Is that a 32-bit Toad version?
Mon May 04, 2015 10:58 am View user's profile Send private message
13th



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

Post Reply with quote
SysOp wrote:
Is that a 32-bit Toad version?
yes.
there is no log by default.. but after running with /SA:TraceLogLevel:9
Quote:
04.05.2015 23:42:10 SqlAssist.exe SA=7.2.328; Exe=C:\Program Files (x86)\SQL Assistant 7\SqlAssist.exe; Cmd="C:\Program Files (x86)\SQL Assistant 7\SqlAssist.exe" /SA:TraceLogLevel:9; LogLvl=9; MsgLvl=0
04.05.2015 23:42:10 SqlAssist.exe Server: CheckInstallation
04.05.2015 23:42:11 SqlAssist.exe Server: Create
04.05.2015 23:42:11 SqlAssist.exe SA=7.2.328; Exe=C:\Program Files (x86)\SQL Assistant 7\SqlAssist.exe; Cmd="C:\Program Files (x86)\SQL Assistant 7\SqlAssist.exe" /SA:TraceLogLevel:9; LogLvl=9; MsgLvl=0
04.05.2015 23:42:11 SqlAssist.exe Client: Attach
04.05.2015 23:42:13 totalcmd.exe SA=7.2.328; Exe=C:\Program Files\total commander 8\totalcmd.exe; Cmd="C:\Program Files\total commander 8\totalcmd.exe" ; LogLvl=9; MsgLvl=0
04.05.2015 23:42:13 totalcmd.exe Client: Attach
04.05.2015 23:42:40 toad.exe SA=7.2.328; Exe=C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe; Cmd="C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe" ; LogLvl=9; MsgLvl=0
04.05.2015 23:42:40 toad.exe Client: Attach
04.05.2015 23:42:40 toad.exe Client: Create
04.05.2015 23:42:57 toad.exe Client: CreateTargetList
04.05.2015 23:42:57 toad.exe SA=7.2.328; Exe=C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe; Cmd="C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe" ; LogLvl=9; MsgLvl=0
04.05.2015 23:42:57 toad.exe Prefs: Attach
04.05.2015 23:42:57 toad.exe TargetList: SetSuspend=0
04.05.2015 23:42:57 toad.exe TargetList: Create: Rok=1
04.05.2015 23:42:57 toad.exe TargetList: SetSuspend=0
04.05.2015 23:42:57 toad.exe TargetList: EnumWnd (class=WindowsForms%.Window.%)
04.05.2015 23:42:57 toad.exe TargetList: EnumWnd (class=TAdvToadSyntaxMemo,TToadSyntaxMemo)
04.05.2015 23:43:02 toad.exe Target: Create: Pref=Toad for SQL Server
04.05.2015 23:43:02 toad.exe Target: Create: Code=7
04.05.2015 23:43:02 toad.exe Warning: Application C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe failed to load SqlAssist.Dex4.dll.
04.05.2015 23:43:02 toad.exe Warning: Application C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe failed to load SqlAssist.Dex4.dll.
04.05.2015 23:43:16 toad.exe PopupInitBars: result=0
04.05.2015 23:43:17 toad.exe Warning: Application C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe failed to load SqlAssist.Dex4.dll.
04.05.2015 23:43:17 toad.exe Warning: Application C:\Program Files (x86)\Dell\Toad for SQL Server 6.5\toad.exe failed to load SqlAssist.Dex4.dll.
04.05.2015 23:43:31 toad.exe PopupInitBars: result=0

Mon May 04, 2015 1:40 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
This is helpful. Thank you.

Please try the following:
Start SQL Assistant in Run as Administrator mode.

Then start Toad in Run as Administrator mode.
Do you get an error? If yes, is that the same error?
If no, restart Toad normally. Do you get an error?

If the above doesn't help. Open SQL Assistant settings, the Options dialog. Click Import/Export button. Click Default checkbox and import all default settings. Click the Apply button to save them.
Start Toad. Does it work now?

If the above doesn't help. Start Toad, open an editor. Press CTRL +Space. Do you see SQL Assistant popup?
Tue May 05, 2015 10:33 am View user's profile Send private message
13th



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

Post Reply with quote
SysOp wrote:
...Run as Administrator mode....

Do you get an error? If yes, is that the same error?

yes, the same error
SysOp wrote:
If the above doesn't help. Open SQL Assistant settings, the Options dialog. Click Import/Export button. Click Default checkbox and import all default settings. Click the Apply button to save them.
Start Toad. Does it work now?
it doesn't work.
SysOp wrote:
If the above doesn't help. Start Toad, open an editor. Press CTRL +Space. Do you see SQL Assistant popup?
i can't even press any key on toad editor, because every time when editor get focus SA showing error message.
Tue May 05, 2015 12:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
Thank you. I will pass that to the crew.

One more question, which .NET versions are installed in c:\Windows\Microsoft.NET\Framework\ folder?
Tue May 05, 2015 2:06 pm View user's profile Send private message
13th



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

Post Reply with quote
.net 4.6 rc
i wonder if you can't catch the error, because i've got it on win7 32 (with .net 4.5), win7 64 (.net 4.5.1-4.6rc) and toad 6-6.5
Wed May 06, 2015 2:32 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
Goto page 1, 2  Next
Page 1 of 2

 
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.