sql server - Can't set msnodesql to work -
sql server - Can't set msnodesql to work -
ok, i've tryed here. did installed msnodesql
-https://github.com/azure/node-sqlserver
and
-http://www.microsoft.com/en-us/download/details.aspx?id=29995
following every line of instruction on installation. build node-gyp... everything.
then when like:
var conn_str = "driver={sql server native client 11.0};server={(local)\\sqlexpress};database={dbname};trusted_connection={yes};"; var stmt = sqlserver.query(conn_str, "select * av.client"); stmt.on('meta', function (meta) { console.log("we've received metadata"); }); stmt.on('row', function (idx) { console.log("we've started receiving row"); }); stmt.on('column', function (idx, data, more) { console.log(idx + ":" + data); }); stmt.on('done', function () { console.log("all done!"); }); stmt.on('error', function (err) { console.log("we had error :-( " + err); });
it throws me error on node console:
[error: [msnodesql] invalid passed function query. type should .]
what drives me crazy should like:
[error: [msnodesql] invalid --something-- passed function query. type should --something_else--.]
right?
it doesn't pass through stmt.on('error', line
i've repeated installation steps on , over, thinking maybe there error in building process, nothing.!
i'm using windows 8 x64 , node v-0.10 (i wonder if driver ment utilize node v.0.8 <
i need help. pls.
i have not used node-sqlserver, have used tedious , worked well. give try, maybe you'll have improve luck?
sql-server node.js azure node-sqlserver
Comments
Post a Comment