Database Configuration to connect with named instance SQL Server with mssql for node.js

After some frustration, it found that Node JS mssql (5.0.5) doesn't like instance name in config file to make mssql.ConnectionPool(config)-

Works


    dbConfig: {
        "user": "user",
        "password": "pass",
        "server": "myserver",  //  Without instance name 
        "database": "dbname",
        "port":1433,
        "driver": "tedious",
        "options": {
            "instance":"mylocaldevdatabase",
            "trustedConnection": true
          }
        }


Doesn't Work




    dbConfig: {
        "user": "user",
        "password": "pass",
        "server": "myserver\\myinstance",  //  With instance name 
        "database": "dbname",
        "port":1433,
        "driver": "tedious",
        "options": {
            "trustedConnection": true
          }
        }


while making connection as in Node Js 

import * as mssql from "mssql";

mssql.ConnectionPool(dbConfig)

Comments

Post a Comment

Popular posts from this blog

Update WPF Interaction Triggers in from .Net Framework 4.8 to .Net 5

  When migrating the Visual Studio projects from .Net Framework 4.8 to .Net 5, you may encounter   in the following error regarding Interaction.Triggers .   Error      XDG0008             The name "Interaction" does not exist in the namespace "http://schemas.microsoft.com/xaml/behaviors".   The one solution to fix it is to install “ Microsoft.Xaml.Behaviors.Wpf ” from Nuget And update the namespace ( if needed) xmlns : i ="http://schemas.microsoft.com/expression/2010/interactivity" to              xmlns:i ="http://schemas.microsoft.com/xaml/behaviors"
Read more

Instruct GIT not to track a specific file

In scenarios like you have a configuration file in  a remote repo for the production environment, and you don’t want to commit the changes to this configuration file made from local.  How do you instruct git to do not track the local changes? --skip-worktree is what you need. git update-index --skip-worktree <filepath/file_name> After index update git won't show you the file in working tree. If you want to track the changes update-index as  git update-index --no-skip-worktree <filepath/file_name>
Read more

[Code Snippet] Assert Exception in private methods using PrivateObject

NON ASYNC Method Method.cs private MyMethod(object value1) {       if(value1 == null)       {            throw new ArgumentNullException(nameof(MyMethod));       } } Test.Cs [TestMethod] public void MyMethod_Throws_Verify() {          PrivateObject po = new PrivateObject(new Method()) TargetInvocationException exception = Assert.ThrowsException<TargetInvocationException>(() =>                     privateObject.Invoke("MyMethod", new object[] { null }));             Assert.AreEqual(typeof(ArgumentNullException), exception.InnerException.GetType());         }
Read more