CDaoWorkspace::SetIsolateODBCTrans

void SetIsolateODBCTrans( BOOL bIsolateODBCTrans );
throw( CDaoException, CMemoryException );

Parameters

bIsolateODBCTrans

 Pass TRUE if you want to begin isolating ODBC transactions. Pass FALSE if you want to stop isolating ODBC transactions.

Remarks

Call this member function to set the value of the DAO IsolateODBCTrans property for the workspace. In some situations, you might need to have multiple simultaneous transactions pending on the same ODBC database. To do this, you need to open a separate workspace for each transaction. Although each workspace can have its own ODBC connection to the database, this slows system performance. Because transaction isolation is not normally required, ODBC connections from multiple workspace objects opened by the same user are shared by default.

Some ODBC servers, such as Microsoft SQL Server, do not allow simultaneous transactions on a single connection. If you need to have more than one transaction at a time pending against such a database, set the IsolateODBCTrans property to TRUE on each workspace as soon as you open it. This forces a separate ODBC connection for each workspace.

For more information about workspaces, see the article DAO Workspace. For more about transactions, see the article DAO Workspace: Managing Transactions. For more about working with ODBC data sources through DAO, see the article DAO External: Working with External Data Sources. All articles are in Visual C++ Programmer's Guide.

CDaoWorkspace OverviewClass MembersHierarchy Chart

See Also   CDaoWorkspace::GetIsolateODBCTrans