7.1.246 and Toad for SQL Server 6.5

7.1.246 and Toad for SQL Server 6.5

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"

Where do you see that error?

on openning new sql editor tab

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?

Toad ver. 6.5.0.3001 Run as Administrator mode = same error

Toad ver. 6.5.0.3001
Run as Administrator mode = same error

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.

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.

thnx! will be waiting.. By the way, toad 6.1 having same problem with sa 7.*

SQL Assistant 7.2.328

	SysOp wrote:
	13. Compatibility changes for latest Toad versions.

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?

	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

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?

	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.

Thank you. I will pass that to the crew.

One more question, which .NET versions are installed in c:\Windows\Microsoft.NET\Framework\ folder?

.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