Export (0) Print
Expand All

Connection Object

SQL Server 2000

A Connection object represents a unique session with a data source. In the case of a client/server database system, it may be equivalent to an actual network connection to the server.

In addition to the standard ADO properties, these dynamic properties are added to the Properties collection of the Connection object.

Dynamic Properties
Active Sessions Property NULL Collation Order Property
Asynchable Abort Property NULL Concatenation Behavior Property
Asynchable Commit Property OLE DB Version Property
Autocommit Isolation Levels Property OLE Object Support Property
Catalog Location Property Open Rowset Support Property
Catalog Term Property ORDER BY Columns in Select List Property
Column Definition Property Output Parameter Availability Property
Connect Timeout Property Pass By Ref Accessors Property
Current Catalog Property Password Property
Data Source Property Persist Security Info Property
Data Source Name Property Persistent ID Type Property
Data Source Object Threading Model Property Prepare Abort Behavior Property
DBMS Name Property Prepare Commit Behavior Property
DBMS Version Property Procedure Term Property
Extended Properties Property Prompt Property
GROUP BY Support Property Provider Friendly Name Property
Heterogeneous Table Support Property Provider Name Property
Identifier Case Sensitivity Property Provider Version Property
Initial Catalog Property Read-Only Data Source Property
Isolation Levels Property Rowset Conversions on Command Property
Isolation Retention Property Schema Term Property
Locale Identifier Property Schema Usage Property
Maximum Index Size Property SQL Support Property
Maximum Row Size Property Structured Storage Property
Maximum Row Size Includes BLOB Property Subquery Support Property
Maximum Tables in SELECT Property Table Term Property
Multiple Parameter Sets Property Transaction DDL Property
Multiple Results Property User ID Property
Multiple Storage Objects Property User Name Property
Multi-Table Update Property Window Handle Property

© 2015 Microsoft