Can't start JavaScript external environment in SA17

[VolkerBarth]

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?

[VolkerBarth]

Just a wild guess: You possibly have to mask the backslashes in the path, such as

LOCATION 'C:\\\\Program Files\\\\nodejs\\\\node.exe';

'\\n' is the new line character.

[Former Member]

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

[Former Member]

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)

[VolkerBarth]

To increase your "happy anticipation", here's what the 17.0.0.1358 "Node\\sqlanywhere_jsextenv\\bin64" directory looks in my case:

[Former Member]

Can't wait !!! 🙂