|
As the question says, I'm having trouble starting the NodeJS/JavaScript external environment in SA17. I'm following the help documentation instructions under "Installing the JavaScript external environment module". The node executable is at C:\Program Files\nodejs\node.exe 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 17.0.0.1211 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. Any suggestions? |
|
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. 1
Thanks to both of you. The problem was indeed related to not having the drivers for node V4.2.6. I reverted my node installation to v0.10.40 and now I can start the external environment and execute JS code. I don't really want to get into recompiling the drivers for node v4.x - is there anyplace from which the binaries can be downloaded?
(09 Feb '16, 10:40)
Terry Wilkinson
|
|
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 Thanks. I'm using the Developer Edition, so I'll have to wait for the next update there (currently I think it is still 17.0.0.1211)
(09 Feb '16, 18:53)
Terry Wilkinson
Replies hidden
To increase your "happy anticipation", here's what the 17.0.0.1358 "Node\sqlanywhere_jsextenv\bin64" directory looks in my case:
(10 Feb '16, 01:18)
Volker Barth
Can't wait !!! :-)
(10 Feb '16, 10:16)
Terry Wilkinson
|
Just a wild guess: You possibly have to mask the backslashes in the path, such as
'\n' is the new line character.