ADO ObjectsLesson 71Free preview
ADO Connection
This lesson is part of ASP · All levels
Summary
The Connection object becomes the main gateway of the ADO to the database, containing the connection string, the connection time limit, and the cursor settings. Important properties include ConnectionString, ConnectionTimeout, State, and CursorLocation. Checking the state before and after work helps you know if the connection is still open.
Key points
- ConnectionString stores the provider and location of the data source.
- ConnectionTimeout determines how long it takes to wait for a connection to open.
- State indicates the connection is open or closed.
- CursorLocation specifies the cursor moved on the client or on the server.
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.