Gets properties of the object as determined by the inputs. This VI works for connections, commands, recordsets, columns, and parameters. Wire data to the reference input to determine the polymorphic instance to use or manually select the instance.


icon

Inputs/Outputs

  • cdlrn.png connection reference —

    connection reference specifies a reference to an ADO Connection object.

  • cerrcodeclst.png error in (no error) —

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

  • idlrn.png connection reference out —

    connection reference out returns a reference to an ADO Connection object.

  • icclst.png connection properties —

    connection properties returns the following properties that define the database connection.

  • ii32.png command timeout (s) —

    command timeout (s) returns the length of time, in seconds, the VI waited while attempting to execute a command before quitting and returning an error.

  • istr.png connection string —

    connection string returns the connection string that the VI used to make the database connection.

  • istr.png default database —

    default database returns the default database the VI used for the connection. Some providers might not support this use of this property.

  • istr.png provider —

    provider returns the provider this VI used to make the database connection.

  • ierrcodeclst.png error out —

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