Connection has no method queryRaw ...?

[pofallon]

I'm not sure if this is an issue or simply an error on my end. I have the driver installed correctly and I'm trying to run a query against an (empty) SQLAzure table. Here is my code:

var sql = require('node-sqlserver');

var server = "... my azure connection string ..."

sql.open(server, function(err, conn) {
  if (err) {
    console.dir(err);
  } else {
    console.dir(conn);
    conn.query('select * from mytable', function(err, results) {
      console.dir(results);
    });
  }
});

When I run this, I get this error:

C:\devtools\temp2\node_modules\node-sqlserver\lib\sql.js:8413: Uncaught TypeError: Object #<Connection> has no method 'queryRaw'

However, (a) when I print out the "conn" object it does show a queryRaw method and (b) when I change my "conn.query(...)" call to "conn.queryRaw(...)" it works.

Am I doing something wrong here that would cause this error? Any help is appreciated!

[jguerin]

You are not doing anything wrong - query was enabled after we released the initial package. Are you on the develop or master branch?

Cheers,

Jonathan

[pofallon]

Ah ok -- I installed via NPM. Should I install from dev or master directly instead? Thanks!

[jguerin]

Yes, please - install from develop and let us know if you still see this issue.

Thanks!

Jonathan

[jguerin]

This appears to be related to #40

[pofallon]

I tried this:

npm install https://github.com/WindowsAzure/node-sqlserver/tarball/develop

but it returns the same error.

[jguerin]

Ok, thanks, we'll investigate this.