Add-in: Log Error

[#1]

I read through post:discussion1 but still I could not resolve my error.

The full script is large so I just condensed it down to a few lines.

When I create the add-in, the Log says:  Name Unresolved: DSN in access or evaluation of 'DSN' , DSN/*###*/

Clear Log();
::DSN = "a64";  
::connection      = eval insert("DSN="||"^DSN^"||";UID=stuff;PWD=place;"); 
ct                = Open("C:\Users\tom_p\Desktop\user-interface\UI_counter.jmp");  
::count_a         = ct:Table_Count[ 1 ];

Any ideas how to overcome? I tried DSN removing the global variable colon,colon (DSN="a64";) and it did not fix the issue. I'm running JMP 16.

[#2 · Accepted solution]

By chance are you using names default to here(1)?  If so JMP might be looking for here:DSN instead of ::DSN.  Give this a try:

::connection      = eval insert("DSN="||"^::DSN^"||";UID=stuff;PWD=place;"); 

this is what your script might be looking for:

::connection      = eval insert("DSN="||"^here:DSN^"||";UID=stuff;PWD=place;"); 

[#3]

Once i saw your definition, i realized i had left "checked":  Use the "Here" namespace for unqualified JSL variable names in the menu items tab.  Unchecking that box let the program load and run.

Your 1st option worked as well

Thanks!