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.


icon

Inputs/Outputs

  • cstr.png userID

    userID specifies the user ID needed to access the database. You might not need to specify a userID.

  • cpath.png 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.

  • cbool.png 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.

  • ci32.png 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.

  • cerrcodeclst.png error in (no error)

    error in describes error conditions that occur before this node runs. This input provides standard error in functionality.

  • cstr.png password

    password specifies the password required to access the database for security purposes. You might not need to specify a password.

  • idlrn.png connection reference

    connection reference returns a reference to an ADO Connection object.

  • ierrcodeclst.png error out

    error out contains error information. This output provides standard error out functionality.