O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Connection Objects

The top level of the ADO object model is the connection object, which describes the access to an OLE DB provider. The client establishes a connection to a server by using the user-entered data to search the network for the server and to log on. The connection can be used to exchange data in both directions. It is possible for a client to maintain multiple connections to a server that can be used to transmit data simultaneously and in parallel, if needed. Every connection requires resources on the client and the server, so normally the system tries to minimize the number of connections.

The Connection object describes the connection between the client and the server. Tables 12-1 through 12-3 list all of the properties, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required