Przepisując kod z dokumentacji Dostaję bład
Requests can only be made in the LoggedIn state, not the Connecting state
Kod jest 1:1 jak w dokumentacji i tak dostaję błąd Kod:
var Connection = require("tedious").Connection;
var config = {
server: "(localdb)MSSQLLocalDB",
authentication: {
type: "default",
options: {
userName: "",
password: "",
},
},
options: {
encrypt: true,
database: "Form",
},
};
var connection = new Connection(config);
connection.on("connect", function (err) {
console.log("Connected");
executeStatement();
});
connection.connect();
var Request = require("tedious").Request;
var TYPES = require("tedious").TYPES;
function executeStatement() {
request = new Request("Select Person.firstName, Person.surname from Person;", function (err) {
if (err) {
console.log(err);
}
});
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");
});
request.on("requestCompleted", function (rowCount, more) {
connection.close();
});
connection.execSql(request);
}
Tak wygląda moja baza]