Node.js and node-sqlanywhere - No Connection Available

Question

I have been trying to use node-sqlanywhere to query my Sybase database.

However, I cannot seem to be able to connect to the database.

var sqlanywhere = require('sqlanywhere');
var sqlanywhere_conn = sqlanywhere.createConnection();

var sqlanywhere_conn_params = {
    DatabaseFile: 'C:\Users\support\Dropbox\database.db',
    AutoStart: 'YES',
    UserId: 'user_id',
    Password: 'password'
};

sqlanywhere_conn.connect(sqlanywhere_conn_params, function(){
    sqlanywhere_conn.prepare('SELECT * FROM some_table WHERE some_column = ?', function (err, stmt){
        if (err) throw err;
      // do something with the statement
    });
});

Whether I am trying to connect to the database using Server attribute or the DatabaseFile attribute, I always get error code -2005 No Connection Available.

That being said, I am able to connect to my database using Interactive SQL by either specifying the server or the database file.

So.. I must be missing something here and I can't figure it out !

Thanks !!

Answer 1

Try doubling up the backslash characters, like DatabaseFile: 'C:\\Users\\support\\Dropbox\\database.db'.

FYI you can also ask SQL Anywhere-specific questions on http://sqlanywhere-forum.sap.com.

Full disclosure: I work for SAP in SQL Anywhere engineering. I am responsible for both the node.js driver and the sqlanywhere-forum.sap.com site.