BOOL DBTest() 
{
	BOOL bret = FALSE;
	Lda_Def lda_1;
	Lda_Def lda_2;
	OCIEnv *myenvh = NULL;
	OCISvcCtx *mysvch = NULL;
	OCIError *myerrh = NULL;
	sword retCode;
	sword swOCIStat;
	HRESULT hr;
	ITransactionDispenser *pTransactionDispenser = NULL;
	ITransaction *pTransaction = NULL;
	EXEC SQL BEGIN DECLARE SECTION;
	char *username;
	char *password;
	char *connectid = "my_connect_id";
	char *dbname;
	EXEC SQL END DECLARE SECTION;
	username = "myusername";
	password = "mypassword";
	dbname = "mydbname";
	EXEC SQL CONNECT :username IDENTIFIED BY: password
	AT :connectid USING :dbname;
	// with oracle manual, call OCI in pro*c, must need this line
	sqllda( &lda_1 );
	retCode = SQLEnvGet( SQL_SINGLE_RCTX, &myenvh );
	retCode = SQLSvcCtxGet( SQL_SINGLE_RCTX, (text *)connectid,
                                (ub4)strlen(connectid), &mysvch );
	hr = DtcGetTransactionManager( NULL, NULL, IID_ITransactionDispenser, 0, 
                                       0, NULL, (void **)&pTransactionDispenser );
	OraMTSSvcEnlist( mysvch, myerrh, (void *)pTransaction,
                         ORAMTS_ENFLG_DEFAULT );
	swOCIStat = OCIHandleAlloc( myenvh, (dvoid **)&myerrh, 
                                    OCI_HTYPE_ERROR, 0, NULL );
	EXEC SQL AT: connectid
	// my update and insert sql
	update ... ...
	hr = pTransaction->Commit( FALSE, XACTTC_SYNC_PHASEONE, 0 );
	pTransaction->Release();
	bret = TRUE;
	return bret
}