Organisations using Smartermail as an email solution face a problem of database backup restoration. After the restoration of the database some emails are shown blank. This is because of the indexing issue. Solution is to copy the inbox folder without copying a file called "mailbox.cfg" that is the configuration file. So delete the file and open the email account. Smartermail will automatically create this file again. This will solve the problem of blank corrupted emails.
Normally we connect Nodejs to the databases like SQLite, MongoDB, Postgres etc . In this multiple part post, I am going to show you, how we can connect Nodejs with Microsoft's SQL Server using Knex and run CRUD operations. 1. Installation of required packages In order to connect Nodejs to SQL Server with Knex, we will need following node packages installation: i. npm install knex ii. npm install mssql Once the packages are installed, we can write the following code to connect: //Code to KNEX connection settings. var knex = require('knex')({ client: 'mssql', connection: { user: 'sa', password: 'pwd', server: 'localhost', database: 'Test' } }); //Code to query the Table DEPT knex.select("*").from("dept") .then(function (depts){ depts.forEach((dept)=>{ //use of Arrow Function console.log({...dept}); }); }).catch(function(err) { ...
Comments