Connection (ADO for Visual C++ syntax)

Applies to: Access 2013 | Access 2016

Methods

BeginTrans(long * TransactionLevel )

CommitTrans(void)

RollbackTrans(void)

Cancel(void)

Close(void)

Execute(BSTR CommandText, VARIANT * RecordsAffected, long Options, _ADORecordset ** ppiRset )

Open(BSTR ConnectionString, BSTR UserID, BSTR Password, long Options )

OpenSchema(SchemaEnum Schema, VARIANT Restrictions, VARIANT SchemaID, _ADORecordset ** pprset )

Properties

get_Attributes(long * plAttr ) put_Attributes (long lAttr )

get_CommandTimeout(LONG * plTimeout ) put_CommandTimeout (LONG lTimeout )

get_ConnectionString(BSTR * pbstr ) put_ConnectionString (BSTR bstr )

get_ConnectionTimeout(LONG * plTimeout ) put_ConnectionTimeout (LONG lTimeout )

get_CursorLocation(CursorLocationEnum * plCursorLoc ) put_CursorLocation (CursorLocationEnum lCursorLoc )

get_DefaultDatabase(BSTR * pbstr ) put_DefaultDatabase (BSTR bstr )

get_IsolationLevel(IsolationLevelEnum * Level ) put_IsolationLevel (IsolationLevelEnum Level )

get_Mode(ConnectModeEnum * plMode ) put_Mode (ConnectModeEnum lMode )

get_Provider(BSTR * pbstr ) put_Provider (BSTR Provider )

get_State(LONG * plObjState )

get_Version(BSTR * pbstr )

get_Errors(ADOErrors ** ppvObject )

Events

BeginTransComplete(LONG TransactionLevel, ADOError * pError, EventStatusEnum * adStatus, _ADOConnection * pConnection )

CommitTransComplete(ADOError * pError, EventStatusEnum * adStatus, _ADOConnection * pConnection )

ConnectComplete(ADOError * pError, EventStatusEnum * adStatus, _ADOConnection * pConnection )

Disconnect(EventStatusEnum * adStatus, _ADOConnection * pConnection )

ExecuteComplete(LONG RecordsAffected, ADOError * pError, EventStatusEnum * adStatus, _ADOCommand * pCommand, _ADORecordset * pRecordset, _ADOConnection * pConnection )

InfoMessage(ADOError * pError, EventStatusEnum * adStatus, _ADOConnection * pConnection )

RollbackTransComplete(ADOError * pError, EventStatusEnum * adStatus, _ADOConnection * pConnection )

WillConnect(BSTR * ConnectionString, BSTR * UserID, BSTR * Password, long * Options, EventStatusEnum * adStatus, _ADOConnection * pConnection )

WillExecute(BSTR * Source, CursorTypeEnum * CursorType, LockTypeEnum * LockType, long * Options, EventStatusEnum * adStatus, _ADOCommand * pCommand, _ADORecordset * pRecordset, _ADOConnection * pConnection )

See also

• Access for developers forum
• Access help on support.office.com
• Access help on answers.microsoft.com
• Access forums on UtterAccess
• Access developer and VBA programming help center (FMS)
• Access posts on StackOverflow

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.