node-sqlserver-v8 icon indicating copy to clipboard operation
node-sqlserver-v8 copied to clipboard

Published 20 hours ago • verified publisher icon TimelordUK

please give node-sqlserver-v8 a try!

Open TimelordUK opened this issue 9 years ago • 6 comments

greetings. I hope you find some use in this module. I intend to add additional features which hopefully will be based on the community feedback. So please feel free to make suggestions for improvements or issues with the new stored procedure feature.

TimelordUK avatar Sep 17 '15 23:09 TimelordUK

This is great!! I am giving it a try and will let you know if I find something. This absolutely amazing though!!!!

meet-bhagdev avatar Sep 25 '15 18:09 meet-bhagdev

Currently using it, works great!

tysjiang avatar Sep 29 '15 21:09 tysjiang

I've never connected to an SQL server from Node so this is all new to me. I haven't been able to get this implementation working. Right now, I'm getting a message:

{ [Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user USERNAME.] sqlstate: '28000', code: 18456 }

Any ideas?

robokozo avatar Oct 07 '15 20:10 robokozo

this error has come back from SQL server, so clearly you are at least communicating with the database. Are you using windows authentication or a database account? The connection has to be configured as below. If you use authentication, set the trusted flag true and the user and password are not therefore required. If the server requires a user and password, then the flag should be false and the credentials set. Is this a local database or an instance maintained by DBA's? How would you connect from Management Studio normally? The configuration below would be precisely inline with your normal access.

var driver = 'SQL Server Native Client 11.0'; var server = '<your_server>'; var user = ''; var pwd = '<password'; var database = 'AdventureWorks2012'; var useTrustedConnection = false; var conn_str = "Driver={" + driver + "};Server=" + server + ";" + (useTrustedConnection == true ? "Trusted_Connection={Yes};" : "UID=" + user + ";PWD=" + pwd + ";") + "Database={" + database + "};";

TimelordUK avatar Oct 07 '15 23:10 TimelordUK

Thanks, TimelordUK. I was able to get it working eventually by using https://www.npmjs.com/package/mssql and renaming your package to stand in for the official MS package in the node_modules folder.

robokozo avatar Oct 08 '15 00:10 robokozo

I'm using this at work, thank you for making it.

paulbjensen avatar Nov 17 '15 10:11 paulbjensen