DB Tools Open Connec (Path) VI
- Updated2024-07-30
- 3 minute(s) read
Opens a database connection using the connection information path and returns a connection reference. If prompt? is set to TRUE, LabVIEW displays a dialog box to set up the connection. Wire data to the connection information input to determine the polymorphic instance to use or manually select the instance.

Inputs/Outputs
userID
—
userID specifies the user ID needed to access the database. You might not need to specify a userID.
connection information
—
connection information is the absolute path of the file that stores the connection information. For a Microsoft Data Link file, this path must have a .udl extension. A File DSN must have a .dsn extension.
prompt? (F)
—
prompt? If TRUE, LabVIEW prompts you to determine connection parameters. Using this input is an alternative to using a connection string. If prompt? is TRUE, LabVIEW ignores the connection string and uses the prompt instead.
connection timeout (15)
—
connection timeout determines the length of time (in seconds) to wait while attempting to make a connection to a database before quitting and returning an error. The default is 15. Setting this value to 0 instructs the VI to wait indefinitely.
error in (no error)
—
error in describes error conditions that occur before this node runs. This input provides standard error in functionality.
password
—
password specifies the password required to access the database for security purposes. You might not need to specify a password.
connection reference
—
connection reference returns a reference to an ADO Connection object.
error out
—
error out contains error information. This output provides standard error out functionality. |
userID
—
connection information
—
prompt? (F)
—
connection timeout (15)
—
error in (no error)
—
connection reference
—
error out
—