SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQLA 12.3.427 - SSMS 19.0.2 No Autocomplete
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQLA 12.3.427 - SSMS 19.0.2 No Autocomplete
Author Message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post SQLA 12.3.427 - SSMS 19.0.2 No Autocomplete Reply with quote
I could not get autocomplete to work for me in SSMS 19.0.2. Worked fine in SSMS 18, upgraded to 19.0.2 and it's no longer working. SQL Assistant shows in the menu when I right click on an object from the Object Explorer. It also shows the confirmation dialog on close.

See below. Has an active query but no SQL Assistant on the main menu but Object Explorer shows that SQLA is loaded.



SSMS version:
SQL Server Management Studio 19.0.20209.0+f9a9d8f6
SQL Server Management Objects (SMO) 16.200.48036.0+7d3b143d945e1aa638acdb02c0364e263d5ec973
Microsoft T-SQL Parser 16.0.22524.0+62eedb15cd3cde34e51c8fbbdf9b06e575ec912e
Microsoft Analysis Services Client Tools 16.0.19993.0
Microsoft Data Access Components (MDAC) 10.0.22000.1574
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22000
Wed May 03, 2023 6:01 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Did that work with SQL Assistant 12.2 before you upgraded to 12.3?
Wed May 03, 2023 8:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Two more questions. In which order were SSMS and SQL Assistant upgraded since the last working state? When you upgraded SQL Assistant, did you run full install and selected Register add-on for SSMS or used Check for Updates and then upgraded existing install? In theory there might be an issue with SSMS add-on for 19 not installed, every version has it's own add-on, technically two, one for the Object Explorer, and one for the SQL editor.
Wed May 03, 2023 8:23 am View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
Was the same with 12.2. I initially got the Object Explorer error, found the forum post and updated the DLL. No more errors after that but autocomplete didn't work - pretty much the same with 12.3.

Here are the steps I've done so far, none worked:

    * I originally had SSMS 18 installed, upgraded to 19, then upgraded SQLA to 12.2.
    * When 12.3 was released, I did an in-place upgrade.
    * Fully uninstalled SQLA, re-installed it again with the register add-on checked.
    * Uninstalled SSMS 18 and SSMS 19, installed SSMS 19, then, installed SQLA 12.3


I also tried registering the addon from SQLA preferences dialog by toggling it to Yes/No. This too didn't work.

Hope that helps.
Wed May 03, 2023 5:24 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
This is very helpful. Thank you. I assume when in SSMS you press Ctrl+Shift+F5 you get Unsupported Window Class error. Correct?
Wed May 03, 2023 6:21 pm View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
Yes, correct


Wed May 03, 2023 6:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Please check in the registry in SSMS settings if SQL Assistant extension is enabled

Under HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\19.0_IsoShell\ExtensionManager\EnabledExtensions there should be a string value named SqlAssist.vs..3d117742-b761-4b83-86ce-ca2aa58a8660,1.0 with a value like C:\Users\<user>\AppData\Local\Microsoft\SQL Server Management Studio\19.0_IsoShell\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\


Last edited by SysOp on Wed May 03, 2023 9:59 pm; edited 1 time in total
Wed May 03, 2023 9:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Where user is your Windows user name
Wed May 03, 2023 9:40 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
And while you are at it, please also check under HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\19.0_IsoShell\Packages\{F94DB1BB-ED07-47E6-8B7E-A895B5ACD398} should be
DWORD value named SkipLoading with value set to 1
Wed May 03, 2023 9:59 pm View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
All of those reg keys check out. I have the enabled extension and SkipLoading = 1.

The value of the key in EnabledExtensions points to a directory with an extension.vsixmanifest file and below is the content of the file:

Code:

<xml>
<Vsix>
  <Identifier>
    <Name>SQL Assistant</Name>
    <Author>SoftTree Technologies</Author>
    <Version>1.0</Version>
    <Description>SQL Assistant Add-In for Visual Studio</Description>
    <Locale>1033</Locale>
    <SupportedProducts>
      <VisualStudio>
        <Edition>Pro</Edition>
      </VisualStudio>
    </SupportedProducts>
    <SupportedFrameworkRuntimeEdition>
  </Identifier>
  <References>
  <Content>
    <MefComponent>C:\Program Files (x86)\SQL Assistant 12\bin\SqlAssist.vs.14.dll</MefComponent>
  </Content>
</Vsix>

Thu May 04, 2023 3:16 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
All is looking good so far. And SSSM seems to be finding the addon, and yet, it's not enabling it. One more ask. In SSMS, in Tools/Customize menu Toolbars, do you see SQL Assistant toolbar listed in available choices? If yes, can you enable it and check if the toolbar appears in Query Editor tabs?
Thu May 04, 2023 7:55 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
We updated the diagnostics utility to help us troubleshoot this setup issue.

Can you please download and run https://www.softtreetech.com//support/files/sqlassist/saDiag.exe and copy the output here?
Thu May 04, 2023 11:09 am View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
No SQL Assistant in toolbar.

Here's the output:
Code:

*************************************************************
* SQL Assistant files                                       *
*************************************************************
Installation directory: C:\Program Files (x86)\SQL Assistant 12
SQL Assistant version: 12.3.427
bin\SqlAssist.exe ... OK
bin\SqlEditor.exe ... OK
bin64\SqlEditor.exe ... OK
bin\sacmd.exe ... OK
bin64\sacmd.exe ... OK
bin\sareg.exe ... OK
bin\saddl.exe ... OK
bin\saDLA.exe ... OK
bin\sascan.exe ... OK
bin64\sascan.exe ... OK
bin\sqleditor_std.exe ... OK
bin\saDiag.exe ... OK
bin64\saDiag.exe ... OK
bin\SqlAssist.dll ... OK
bin64\SqlAssist.dll ... OK
bin\SqlAssistPrefs.dll ... OK
bin64\SqlAssistPrefs.dll ... OK
bin\sqlite3.dll ... OK
bin\saResDrk.dll ... OK
bin\saResLgt.dll ... OK
bin64\sqlite3.dll ... OK
bin\SqlAssist.mwb64.dll ... OK
SqlAssist.pdf ... OK
config\SqlAssist.sas ... OK
config\SqlAssist.setup.sas ... OK
config\SqlAssistDTMap.xml ... OK
config\dbdiagram.themes ... OK
bin\SqlAssist.DocMng.dll ... OK
bin\SqlAssist.Sms.dll ... OK
bin\SqlAssist.vs.dll ... OK
bin\SqlAssist.vs.14.dll ... OK
bin\SqlAssist.dll ... OK
bin\SqlAssistPrefs.dll ... OK
bin\SqlAssist.Dbm.dll ... OK
bin\SqlAssist.Ase.dll ... OK
bin\SqlAssist.Dex.dll ... OK
bin\SqlAssist.Mso.dll ... OK
bin\SqlAssist.mwb.dll ... OK
bin\SqlAssist.mwb4.dll ... OK
bin\SqlAssist.Ase4.dll ... OK
bin\SqlAssist.Dex4.dll ... OK
bin\SqlAssist.DDL.dll ... OK
bin\SqlAssist.re.dll ... OK
bin\SqlAssist.Plugins.dll ... OK
bin\SqlAssist.Sms.Bars.dll ... OK
bin\SqlAssist.SSMS2005.dll ... OK
bin\SqlAssist.SSMS2005Ent.dll ... OK
bin\SqlAssist.SSMS2005Std.dll ... OK
bin\SqlAssist.SSMS2008.dll ... OK
bin\SqlAssist.SSMS2008R2.dll ... OK
bin\SqlAssist.SSMS2012.dll ... OK
bin\SqlAssist.SSMS2014.dll ... OK
bin\SqlAssist.SSMS2016.dll ... OK
bin\SqlAssist.SSMS2017.dll ... OK
bin\SqlAssist.SSMS2019.dll ... OK
bin\SA_SqlEdit.dll ... OK
bin\SA_SqlEdit9.bpl ... OK
bin\SA_SqlEdit10.bpl ... OK
bin\SA_SqlEdit11.bpl ... OK
bin\SA_SqlEdit12.bpl ... OK
bin\SA_SqlEdit14.bpl ... OK
bin\SA_SqlEdit15.bpl ... OK
bin\SA_SqlEdit16.bpl ... OK
bin\SA_SqlEdit17.bpl ... OK
bin\SA_SqlEdit18.bpl ... OK
bin\SA_SqlEdit19.bpl ... OK
bin\SA_SqlEdit20.bpl ... OK
bin\SA_SqlEdit21.bpl ... OK
bin\SA_SqlEdit22.bpl ... OK
bin\SA_SqlEdit23.bpl ... OK
bin\git-credential-winstore.exe ... OK

*************************************************************
* User registration                                         *
*************************************************************
Access rights: not elevated
UAC Level: DEFAULT NOTIFICATION (2)
Registration mode: Current User
All users serial ... NO
Current user serial ... NO
SQL Assistant is not registered

*************************************************************
* COM Objects (x86)                                         *
*************************************************************
Loading SqlAssist.Dbm.DbManager... OK
Loading SqlAssist.DDLLoader... OK
Loading SqlAssist.saRegExpr... OK
Loading SqlAssist.CSqlClient... OK
Loading SqlAssist.CSmsAddin... FAILED
Error = 0x80070002: The system cannot find the file specified.

Loading SqlAssist.CSmsAddin10... FAILED
Error = 0x80070002: The system cannot find the file specified.

Loading SqlAssist.MySQLWBAddin... OK
Loading SqlAssist.MySQLWBAddin4... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Dex.DotNetBars... OK
Loading SqlAssist.Mso.Addin... OK
Loading SqlAssist.Ase.Editor... OK
Loading SqlAssist.Ase.DbManager... OK
Loading SqlAssist.Dex.XtraBars... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK
Loading SqlAssist.Ase.ToadDocumentManager... OK

*************************************************************
* SQL Assistant Add-ons                                     *
*************************************************************
SSMS 2005 COM ... NO REGISTRATION INFO
SSMS 2008 COM ... NO REGISTRATION INFO
SSMS 2012 PCKG ... NOT REGISTERED
SSMS 2014 PCKG ... NOT REGISTERED
SSMS 2016 PCKG ... NOT REGISTERED
SSMS 2017 PCKG ... NOT REGISTERED
SSMS 2019 PCKG ... REGISTERED
SSMS 2022 PCKG ... REGISTERED
SSMS 2012 MEF ... TARGET NOT INSTALLED
SSMS 2014 MEF ... TARGET NOT INSTALLED
SSMS 2016 MEF ... TARGET NOT INSTALLED
SSMS 2017 MEF ... TARGET NOT INSTALLED
SSMS 2019 MEF ... TARGET NOT INSTALLED
SqlAssist.vs.14.dll not found in MEF Cache
SSMS 2022 MEF ... REGISTERED

VS 2005 ... NOT REGISTERED
VS 2008 ... NOT REGISTERED
VS 2010, 2012, 2013, 2015 COM Add-on ... NOT REGISTERED
VS 2010 MEF ... TARGET NOT INSTALLED
VS 2012 MEF ... TARGET NOT INSTALLED
VS 2013 MEF ... TARGET NOT INSTALLED
VS 2015 MEF ... TARGET NOT INSTALLED
VS 2017 MEF ... NOT REGISTERED
VS 2019 MEF ... NOT REGISTERED

MS Access ... NOT REGISTERED

Delphi 2005 ... NOT INSTALLED
Delphi 2006 ... NOT INSTALLED
Delphi 2007 ... NOT INSTALLED
Delphi 2009 ... NOT INSTALLED
Delphi 2010 ... NOT INSTALLED
Delphi XE ... NOT INSTALLED
Delphi XE 2 ... NOT INSTALLED
Delphi XE 3 ... NOT INSTALLED
Delphi XE 4 ... NOT INSTALLED
Delphi XE 5 ... NOT INSTALLED
Delphi XE 6 ... NOT INSTALLED
Delphi XE 7 ... NOT INSTALLED
Delphi XE 8 ... NOT INSTALLED
Delphi XE 10 ... NOT INSTALLED

SQL Assistant diagnostics completed ... WITH ERRORS

Thu May 04, 2023 5:22 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Thanks a ton! Please give us a little while to analyze the log.
Thu May 04, 2023 5:33 pm View user's profile Send private message
stynx



Joined: 03 May 2023
Posts: 9
Country: United States

Post Reply with quote
No worries. Hopefully that's enough info to figure out what's going wrong. Just adding a bit more info (and you can probably confirm this through the log), I only had SSMS extension checked on my last install and nothing else.
Thu May 04, 2023 7:54 pm 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.