Merge pull request #11187 from MightyPen/july07i

MightyPen · web-flow · commit 2fd309aeb201 · 2019-07-23T10:23:20.000-07:00
Fix Issue 2389, Node.js connect. From abandoned public PR 2585 (David-Engel).
diff --git a/docs/connect/node-js/step-3-proof-of-concept-connecting-to-sql-using-node-js.md b/docs/connect/node-js/step-3-proof-of-concept-connecting-to-sql-using-node-js.md
@@ -1,7 +1,7 @@
 ---
 title: "Step 3: Proof of concept connecting to SQL using Node.js | Microsoft Docs"
 ms.custom: ""
-ms.date: "08/08/2017"
+ms.date: "07/23/2019"
 ms.prod: sql
 ms.prod_service: connectivity
 ms.reviewer: ""
@@ -26,15 +26,23 @@ The **new Connection** function is used to connect to SQL Database.
 ```javascript  
     var Connection = require('tedious').Connection;  
     var config = {  
-        userName: 'yourusername',  
-        password: 'yourpassword',  
-        server: 'yourserver.database.windows.net',  
-        // If you are on Microsoft Azure, you need this:  
-        options: {encrypt: true, database: 'AdventureWorks'}  
+        server: 'your_server.database.windows.net',  //update me
+        authentication: {
+            type: 'default',
+            options: {
+                userName: 'your_username', //update me
+                password: 'your_password'  //update me
+            }
+        },
+        options: {
+            // If you are on Microsoft Azure, you need encryption:
+            encrypt: true,
+            database: 'your_database'  //update me
+        }
     };  
     var connection = new Connection(config);  
     connection.on('connect', function(err) {  
-    // If no error, then good to proceed.  
+        // If no error, then good to proceed.
         console.log("Connected");  
     });  
 ```  
@@ -48,12 +56,20 @@ All SQL statements are executed using the **new Request()** function. If the sta
 ```javascript  
     var Connection = require('tedious').Connection;  
     var config = {  
-        userName: 'yourusername',  
-        password: 'yourpassword',  
-        server: 'yourserver.database.windows.net',  
-        // When you connect to Azure SQL Database, you need these next options.  
-        options: {encrypt: true, database: 'AdventureWorks'}  
-    };  
+        server: 'your_server.database.windows.net',  //update me
+        authentication: {
+            type: 'default',
+            options: {
+                userName: 'your_username', //update me
+                password: 'your_password'  //update me
+            }
+        },
+        options: {
+            // If you are on Microsoft Azure, you need encryption:
+            encrypt: true,
+            database: 'your_database'  //update me
+        }
+    }; 
     var connection = new Connection(config);  
     connection.on('connect', function(err) {  
         // If no error, then good to proceed.  
@@ -97,11 +113,19 @@ In this example you will see how to execute an [INSERT](../../t-sql/statements/i
 ```javascript  
     var Connection = require('tedious').Connection;  
     var config = {  
-        userName: 'yourusername',  
-        password: 'yourpassword',  
-        server: 'yourserver.database.windows.net',  
-        // If you are on Azure SQL Database, you need these next options.  
-        options: {encrypt: true, database: 'AdventureWorks'}  
+        server: 'your_server.database.windows.net',  //update me
+        authentication: {
+            type: 'default',
+            options: {
+                userName: 'your_username', //update me
+                password: 'your_password'  //update me
+            }
+        },
+        options: {
+            // If you are on Microsoft Azure, you need encryption:
+            encrypt: true,
+            database: 'your_database'  //update me
+        }
     };  
     var connection = new Connection(config);  
     connection.on('connect', function(err) {  
