Guest User

Untitled

a guest
Jan 24th, 2018
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.09 KB | None | 0 0
  1. Connected
  2. { RequestError: Requests can only be made in the LoggedIn state, not the Connecting state
  3. at RequestError (C:WorkspaceVisual-CodenodeApinode_modulestediousliberrors.js:34:12)
  4. at Connection.makeRequest (C:WorkspaceVisual-CodenodeApinode_modulestediouslibconnection.js:1423:33)
  5. at Connection.execSql (C:WorkspaceVisual-CodenodeApinode_modulestediouslibconnection.js:1194:19)
  6. at executeStatement (C:WorkspaceVisual-CodenodeApinodeapi.js:41:20)
  7. at Connection.<anonymous> (C:WorkspaceVisual-CodenodeApinodeapi.js:14:9)
  8. at emitOne (events.js:116:13)
  9. at Connection.emit (events.js:211:7)
  10. at Connection.socketError (C:WorkspaceVisual-CodenodeApinode_modulestediouslibconnection.js:869:14)
  11. at C:WorkspaceVisual-CodenodeApinode_modulestediouslibconnection.js:739:25
  12. at GetAddrInfoReqWrap.callback (C:WorkspaceVisual-CodenodeApinode_modulestediouslibconnector.js:68:18)
  13. message: 'Requests can only be made in the LoggedIn state, not the
  14. Connecting state',
  15. code: 'EINVALIDSTATE' }
  16.  
  17. var Connection = require('tedious').Connection;
  18. var config = {
  19. userName: 'Cool userName',
  20. password: 'awesome password',
  21. server: 'amazing server',
  22. options: {
  23. database: 'database',
  24. }
  25. };
  26. var connection = new Connection(config);
  27. connection.on('connect', function(err) {
  28. // If no error, then good to proceed.
  29. console.log("Connected");
  30. executeStatement();
  31. });
  32.  
  33. var Request = require('tedious').Request;
  34. var TYPES = require('tedious').TYPES;
  35.  
  36. function executeStatement() {
  37. request = new Request("select * from Artikelstamm;", function(err) {
  38. if (err) {
  39. console.log(err);}
  40. });
  41. var result = "";
  42. request.on('row', function(columns) {
  43. columns.forEach(function(column) {
  44. if (column.value === null) {
  45. console.log('NULL');
  46. } else {
  47. result+= column.value + " ";
  48. }
  49. });
  50. console.log(result);
  51. result ="";
  52. });
  53.  
  54. request.on('done', function(rowCount, more) {
  55. console.log(rowCount + ' rows returned');
  56. });
  57. connection.execSql(request);
  58. }
Add Comment
Please, Sign In to add comment