topic Add-in: Log Error in Discussions

Add-in: Log Error

Tom_P — Fri, 09 Jun 2023 18:02:17 GMT

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.

Re: Add-in: Log Error

ih — Tue, 12 Oct 2021 21:34:42 GMT

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;");

Re: Add-in: Log Error

Tom_P — Wed, 13 Oct 2021 13:21:49 GMT

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!