Styjun

Floating Point XOR

Why is the car dealer insisting on a loan instead of cash?

Who are the people reviewing far more papers than they're submitting for review?

What if I don't know whether my program will be linked to a GPL library or not?

Amortized Loans seem to benefit the bank more than the customer

What does this Blight Tower UI mean?

Why is the year in this ISO timestamp not 2019?

Writing a system of Linear Equations

Asked to Not Use Transactions and to Use A Workaround to Simulate One

How would you translate Evangelii Nuntiandi?

Unpredictability of Stock Market

What does the "capacitor into resistance" symbol mean?

Is there a tool to measure the "maturity" of a code in Git?

How to convert Mn2O3 to Mn3O4?

Answer Not A Fool, or Answer A Fool?

Output Distinct Factor Cuboids

Very lazy puppy

Why does '/' contain '..'?

What's the benefit of prohibiting the use of techniques/language constructs that have not been taught?

Why does an orbit become hyperbolic when total orbital energy is positive?

Impossible Scrabble Words

In what state are satellites left in when they are left in a graveyard orbit?

Permutations in Disguise

How clean are pets?

Problem with request to SQL Server DB with tedious

Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerHow to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerInserting multiple rows in a single SQL query?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerHow to Delete using INNER JOIN with SQL Server?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am having a problem with sending a simple request to SQL Server, I am using tedious package and I am getting this error:

"RequestError: Requests can only be made in the LoggedIn state, not
the Connecting state".

I got a message that the node has connected to the DB, but after I want to execute select I get this message.

I got two servers:

1. App server


2. List item

DB Server

var fs = require("fs");
var Connection = require('tedious').Connection;
var config = 
 userName: 'xxxx',
 password: 'xxxx',
 //server: 'xxxx', 
 server: 'xxxx',
 // If you are on Microsoft Azure, you need this: 
 options: //encrypt: true, 
 database: 'xxxx'
 
;
var connection = new Connection(config);
connection.on('connect', function (err) 
 // If no error, then good to proceed. 
 console.log("Connected");

 connection.on('debug', function (err) console.log('debug:', err); );

 executeStatement();
);

var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;

function executeStatement() 
 // Provjeravam je li mi se spojio na server:
 connection.on('debug', function (err) console.log('debug:', err); );

 // funkcija za sustav:

 request = new Request('SELECT * FROM NARANOTIFIKACIJEM1;', function (err) 
 if (err) 
 console.log(err);
 fs.writeFile("temp.txt", err, function (err, data) 
 if (err) console.log(err);
 console.log("Successfully Written to File.");
 );
 
 );
 var result = "";
 request.on('row', function (columns) 
 columns.forEach(function (column) 
 if (column.value === null) 
 console.log('NULL');
 else 
 result += column.value + " ";
 
 );
 console.log(result);
 result = "";
 );

 request.on('done', function (rowCount, more) 
 console.log(rowCount + ' rows returned');
 );
 connection.execSql(request);

node.js sql-server tedious

share|improve this question

edited Mar 28 at 13:55

Dino Filipovic

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges

add a comment
 | 

0

I am having a problem with sending a simple request to SQL Server, I am using tedious package and I am getting this error:

"RequestError: Requests can only be made in the LoggedIn state, not
the Connecting state".

I got a message that the node has connected to the DB, but after I want to execute select I get this message.

I got two servers:

1. App server


2. List item

DB Server

var fs = require("fs");
var Connection = require('tedious').Connection;
var config = 
 userName: 'xxxx',
 password: 'xxxx',
 //server: 'xxxx', 
 server: 'xxxx',
 // If you are on Microsoft Azure, you need this: 
 options: //encrypt: true, 
 database: 'xxxx'
 
;
var connection = new Connection(config);
connection.on('connect', function (err) 
 // If no error, then good to proceed. 
 console.log("Connected");

 connection.on('debug', function (err) console.log('debug:', err); );

 executeStatement();
);

var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;

function executeStatement() 
 // Provjeravam je li mi se spojio na server:
 connection.on('debug', function (err) console.log('debug:', err); );

 // funkcija za sustav:

 request = new Request('SELECT * FROM NARANOTIFIKACIJEM1;', function (err) 
 if (err) 
 console.log(err);
 fs.writeFile("temp.txt", err, function (err, data) 
 if (err) console.log(err);
 console.log("Successfully Written to File.");
 );
 
 );
 var result = "";
 request.on('row', function (columns) 
 columns.forEach(function (column) 
 if (column.value === null) 
 console.log('NULL');
 else 
 result += column.value + " ";
 
 );
 console.log(result);
 result = "";
 );

 request.on('done', function (rowCount, more) 
 console.log(rowCount + ' rows returned');
 );
 connection.execSql(request);

node.js sql-server tedious

share|improve this question

edited Mar 28 at 13:55

Dino Filipovic

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges

add a comment
 | 

I am having a problem with sending a simple request to SQL Server, I am using tedious package and I am getting this error:

"RequestError: Requests can only be made in the LoggedIn state, not
the Connecting state".

I got a message that the node has connected to the DB, but after I want to execute select I get this message.

I got two servers:

1. App server


2. List item

DB Server

var fs = require("fs");
var Connection = require('tedious').Connection;
var config = 
 userName: 'xxxx',
 password: 'xxxx',
 //server: 'xxxx', 
 server: 'xxxx',
 // If you are on Microsoft Azure, you need this: 
 options: //encrypt: true, 
 database: 'xxxx'
 
;
var connection = new Connection(config);
connection.on('connect', function (err) 
 // If no error, then good to proceed. 
 console.log("Connected");

 connection.on('debug', function (err) console.log('debug:', err); );

 executeStatement();
);

var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;

function executeStatement() 
 // Provjeravam je li mi se spojio na server:
 connection.on('debug', function (err) console.log('debug:', err); );

 // funkcija za sustav:

 request = new Request('SELECT * FROM NARANOTIFIKACIJEM1;', function (err) 
 if (err) 
 console.log(err);
 fs.writeFile("temp.txt", err, function (err, data) 
 if (err) console.log(err);
 console.log("Successfully Written to File.");
 );
 
 );
 var result = "";
 request.on('row', function (columns) 
 columns.forEach(function (column) 
 if (column.value === null) 
 console.log('NULL');
 else 
 result += column.value + " ";
 
 );
 console.log(result);
 result = "";
 );

 request.on('done', function (rowCount, more) 
 console.log(rowCount + ' rows returned');
 );
 connection.execSql(request);

node.js sql-server tedious

share|improve this question

edited Mar 28 at 13:55

Dino Filipovic

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges

var fs = require("fs");
var Connection = require('tedious').Connection;
var config = 
 userName: 'xxxx',
 password: 'xxxx',
 //server: 'xxxx', 
 server: 'xxxx',
 // If you are on Microsoft Azure, you need this: 
 options: //encrypt: true, 
 database: 'xxxx'
 
;
var connection = new Connection(config);
connection.on('connect', function (err) 
 // If no error, then good to proceed. 
 console.log("Connected");

 connection.on('debug', function (err) console.log('debug:', err); );

 executeStatement();
);

var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;

function executeStatement() 
 // Provjeravam je li mi se spojio na server:
 connection.on('debug', function (err) console.log('debug:', err); );

 // funkcija za sustav:

 request = new Request('SELECT * FROM NARANOTIFIKACIJEM1;', function (err) 
 if (err) 
 console.log(err);
 fs.writeFile("temp.txt", err, function (err, data) 
 if (err) console.log(err);
 console.log("Successfully Written to File.");
 );
 
 );
 var result = "";
 request.on('row', function (columns) 
 columns.forEach(function (column) 
 if (column.value === null) 
 console.log('NULL');
 else 
 result += column.value + " ";
 
 );
 console.log(result);
 result = "";
 );

 request.on('done', function (rowCount, more) 
 console.log(rowCount + ' rows returned');
 );
 connection.execSql(request);

node.js sql-server tedious

node.js sql-server tedious

share|improve this question

edited Mar 28 at 13:55

Dino Filipovic

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges

share|improve this question

edited Mar 28 at 13:55

Dino Filipovic

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges

asked Mar 28 at 13:01

Dino FilipovicDino Filipovic

361010 bronze badges