The node executable is at
The path is in the PATH variable (the 'where' command finds it).
The NODE_PATH points to
C:\Program Files\SQL Anywhere 17\Node;C:\Users\twilkinson\AppData\Roaming\npm\node_modules
I've set the external environment with
ALTER EXTERNAL ENVIRONMENT JS LOCATION 'C:\Program Files\nodejs\node.exe';
However, when I try to start the external environment as instructed,
START EXTERNAL ENVIRONMENT JS;there is a long pause and then
Could not execute statement. External environment failed to start and establish a connection within the 45 second timeout SQLCODE=-1556, ODBC 3 State="HY000" Line 1, column 1 START EXTERNAL ENVIRONMENT JS
The system is Windows 7, SQL Anywhere Developer Edition 18.104.22.1681 and node v4.2.6. Both node and SA17 are the 64-bit versions.
I assume I'm missing something basic here, but can seem to see it.
Since you are running with the 4.2.6 version of Node.JS you might want to verify this behavior with the latest drivers available from GitHub Support for JS 4.x was added late last year.
If you are running the database server as a Windows Service then you will want to make certain that SYSTEM (or the account the service is running with) has permissions to scan and execute your node directories and binaries.
Do let us know if the symptoms change at all with either of those suggestions.
Newer drivers (pre-built) are available with either of the next 2 patches that should help.
These appear to be available on the http://support.sap.com site:
SQLANYW170000P_3-71001031.ZIP EBF 25687: 17.0.0 SP0 PL3 Build 1328 SQLANYW170000P_4-71001031.ZIP EBF 25692: 17.0.0 SP0 PL4 Build 1358
answered 09 Feb '16, 16:56
Nick Elson S...