open connection

This block is part of the mssql group and was last modified in core v15.0.0.

open connection v15.0.0

Opens a MSSQL connection.

In pins 6 + flow
  • flow
    flow
  • user required
    value
  • password required
    value
  • server required
    value
  • database required
    value
  • encrypt required
    condition

    Default false

  • trust server certificate v15.0.0
    condition

    Accept the server's certificate without verifying it. Off (the default) the certificate must validate, which is what the Node core has always required; on, an encrypted connection authenticates nobody and the credentials go to whatever answered the address. Only for a server with a self-signed certificate you cannot replace.

    Default false

Out pins 2 + flow
  • flow
    flow
  • connection
    mssqlconnection
  • error
    value

A typical wiring for open connection: a function trigger starts the flow; the flow out pin feeds debug.

Studio canvas example for the open connection block: typical wiring for open connection.

Version history

Introduced in v15.0.0.


Back to mssql Return to the main group to view all sub-groups Back to mssql Return to the group to view all blocks within this group