No right click context in Notepad++ or Access 2003

Even though the context menu's are set appropriately neither of these programs has a right click "SQL Assistant" context menu? it seems as if they should

Notepad++ is v6.3.3
Access is 2003 SP3.

Right click tray icon ->target works for NP++ but not for Access.

OK. I got Right Click Context in Access 2003, I had to change Register SQL Assistant Add-On to Yes for MS Access to get the context menu.

However, no such item exists for NotePad++.. and still no right click context menu. Also NP++ "Target" is grayed out in the tray menu seemingly more often than not...

Is that a 32-bit version of Notepad++?
Is SA icon running in the system tray?

	SysOp wrote:
	Is that a 32-bit version of Notepad++? Is SA icon running in the system tray?

yes the S.A icon is in system tray.

NP++ is indeed the 32 bit version. I just checked taskmanager.

Ctrl+Shift+F5 works in NP++ to allow you to set up the linking (which is already set up).. and hotkeys such as Ctrl+F11 or Ctrl+Shift+F9 work just fine.

I can write out a select query and it pulls in the tables from my SQL DB as well. Just no context menu.

Oddly enough the system tray "target" menu is greyed out for SSMS as well.... yet the context menu is there.

I've completely reset S.A's settings and target is still greyed out for everything but context menus (aside from NPP+) are there..

*Edit: Now SSMS 'target' from systray is works.. (just seconds after posting this)

The Target menu in the system tray is used only when SA is used with a target without add-on or plugin based interface and the target is having a focus.

SSMS and Access are using add-on based integration interfaces. Notepad++ is not not. In other words, you can use SA with SQL Assistant without having SQL Assistant running in the system tray. Almost all functions will be accessible directly from SSMS. You cannot use Notepad++ without SQL Assistant running in the system tray.

As for the context menu try changing the options for Notepad++target in SA settings. in the Advanced section set the Environment Integration option to Full and see if that will add a top level or context menu with SA items to Notepad++ menus.

Lastly, my local Notepad++ version is 5.4.5 and the context menu works just fine in that version. Your version seems to be very recent and it could be very different, as a result, the context menu isn't working in that version. I hope someone can tell us if they have the same Notepad++ version as your and whether they are having the same issue.

In any case I hope the "Full" option will put the top level menu in place and that will provide an acceptable workaround.

Confirmed, the default settings no longer work in Notepad++ 6.3.3. The probable cause is that the window class has been changed. The earlier versions had "Scintilla" as window class but 6.3.3 has "Notepad++". Replacing "Scintilla" with "Notepad++" in SA Options > Targets > Registered Targets >Notepad++ >Advanced > Target Window Class will make SA operational once again (or so I guess).

EDIT: Yet the target control class is (remained) Scintilla1. I'm not sure what's the solution here. Experimenting with different settings in Target Window Class might reveal something...
EDIT2: Weird. I created a copy of the target and changed Target Window Class to "Notepad++". Nothing happened. I and restarted both SA and Notepad++. And suddenly it worked. I restarted Notepad++ again and it did not work. I disabled the new target (the one with "Notepad++" as Target Window Class") and enabled the old one again and now it works again. Weird, indeed.

Good to know it's not just me.

	Mindflux wrote:
	Good to know it's not just me.

Did you manage to make it work? Because it didn't happen here since. I guess it was some confusion when I installed notebook++ with SA running in the background.

gemisigo wrote:

	Mindflux wrote:
	Good to know it's not just me.

Did you manage to make it work? Because it didn't happen here since. I guess it was some confusion when I installed notebook++ with SA running in the background.

No, If I change the active window class to Notepad++ I don't even get a connection dialog after typing SELECT. If I leave it Scintilla at least that works.

	Mindflux wrote:
	No, If I change the active window class to Notepad++ I don't even get a connection dialog after typing SELECT. If I leave it Scintilla at least that works.

I've restored that to Scintilla to make it work again.

gemisigo wrote:

	Mindflux wrote:
	No, If I change the active window class to Notepad++ I don't even get a connection dialog after typing SELECT. If I leave it Scintilla at least that works.

I've restored that to Scintilla to make it work again.

So same symptoms. I'm assuming you do not get the right click context menu?

Mindflux wrote:

gemisigo wrote:

	Mindflux wrote:
	No, If I change the active window class to Notepad++ I don't even get a connection dialog after typing SELECT. If I leave it Scintilla at least that works.

I've restored that to Scintilla to make it work again.

So same symptoms. I'm assuming you do not get the right click context menu?

On the contrary, I do. Could you post your target settings here so I can compare them to mine?

gemisigo wrote:

Mindflux wrote:

gemisigo wrote:

	Mindflux wrote:
	No, If I change the active window class to Notepad++ I don't even get a connection dialog after typing SELECT. If I leave it Scintilla at least that works.

I've restored that to Scintilla to make it work again.

So same symptoms. I'm assuming you do not get the right click context menu?

On the contrary, I do. Could you post your target settings here so I can compare them to mine?

You do?...

When I right click in the editor window I don't have an SQL Assistant menu there.. if I use the systray, Target does have the proper menu's.