Table Of Contents

Open Connection (Path) (G Dataflow)

Version:
Last Modified: February 27, 2020

Opens a database connection using a path and returns a connection reference. Open Connection supports connections using both Data Source Names (DSNs) and Universal Data Links (UDLs).

connector_pane_image
datatype_icon

connection information

Absolute path of the file that stores the connection information.

For a Microsoft Data Link file, this path must have a .UDL extension. For a DSN file, this path must have a .DSN extension.

datatype_icon

prompt?

A Boolean value that determines whether to prompt you to determine connection parameters.

spd-note-note
Note  

If set to TRUE, ignores the connection string and uses the prompt instead.

datatype_icon

connection timeout

Length of time (in seconds) to wait while connecting to a database before quitting and returning an error.

Setting the value to 0 will cause node to wait indefinitely.

Default: 15

datatype_icon

error in

Error conditions that occur before this node runs.

The node responds to this input according to standard error behavior.

Standard Error Behavior

Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.

error in does not contain an error error in contains an error
If no error occurred before the node runs, the node begins execution normally.

If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out.

If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out.

Default: No error

datatype_icon

userID

Identification credential to access the database.

datatype_icon

password

Password required to connect to the database.

datatype_icon

connection reference out

Reference to an ADO Connection object. Connection objects represent a connection with a data source, including methods to open and close a connection with a database, which database to connect with, and the level of isolation for database transactions.

datatype_icon

error out

Error information.

The node produces this output according to standard error behavior.

Standard Error Behavior

Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.

error in does not contain an error error in contains an error
If no error occurred before the node runs, the node begins execution normally.

If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out.

If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out.

Where This Node Can Run:

Desktop OS: Windows

FPGA: Not supported

Web Server: Not supported in VIs that run in a web application


Recently Viewed Topics