Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

activex
ado
c++
visual
basic

What is the activeX data object (ADO) connection object?

Behzad Ahmad

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

The ActiveX Data Object (ADO) module is a programming model that enables programs in C++ and Visual Basic to be connected to a database or SQL server.

It includes different types of objects, such as the ADO connection object. This object creates an open connection with a data source. With the help of this connection, we can access and manipulate the database.

We can establish the connection with the help of a connection object if we want to access the database multiple times.

The connection object has certain properties associated with it, which are described below.

Properties

  • Mode: This sets or returns the provider access permissions. It can only be set once the connection object has been closed.

  • Version: This returns the ADO version number.

  • State: This sets or returns the value that describes whether the connection is open or closed.

  • Provider: This sets or returns the provider name. This property is read/write if the connection is closed. However, it is read-only if the connection is open.

  • Attributes: This sets or returns the attributes of a connection object as a long value. For a connection object, this property is read/write.

  • IsolationLevel: This sets or returns the isolation level and is a read/write property.

  • DefaultDatabase: This sets or returns the name of the default database as a string value.

  • ConnectionTimeout: This sets or returns the number of seconds to wait for a connection to open before it is terminated and an error is raised.

  • ConnectionString: This sets or returns the details which are used to create a connection with the data source.

  • CommandTimeout: This sets or returns the number of seconds to wait if we want to execute a command before the command is terminated.

  • CursorLocation: This sets or returns the location of a cursor service as a long value of the CursorLocationEnum type.

RELATED TAGS

activex
ado
c++
visual
basic

CONTRIBUTOR

Behzad Ahmad
Copyright ©2022 Educative, Inc. All rights reserved

Grokking Modern System Design Interview for Engineers & Managers

Ace your System Design Interview and take your career to the next level. Learn to handle the design of applications like Netflix, Quora, Facebook, Uber, and many more in a 45-min interview. Learn the RESHADED framework for architecting web-scale applications by determining requirements, constraints, and assumptions before diving into a step-by-step design process.

Keep Exploring