class CmyAccessor      //Создал акцессор
{
public:
	LONG m_column1;	//	Поля данных
         LONG m_column2;
         ...

BEGIN_COLUMN_MAP(CmyAccessor)
	COLUMN_ENTRY( 1 , m_column1)
	COLUMN_ENTRY( 2 , m_column2)
        ...
END_COLUMN_MAP()
	// You may wish to call this function if you are inserting a record and wish to
	// initialize all the fields, if you are not going to explicitly set all of them.
	void ClearRecord()
	{
		memset(this,  0 , sizeof(*this));
	}
};

HRESULT CmyData::OpenDB()      // Открываю datasource и session
{
		HRESULT		hr;
		CDBPropSet	dbinit(DBPROPSET_DBINIT);

		dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);
		dbinit.AddProperty(DBPROP_AUTH_USERID, OLESTR("sa"));
		dbinit.AddProperty(DBPROP_INIT_CATALOG, OLESTR("data"));
		dbinit.AddProperty(DBPROP_INIT_DATASOURCE, OLESTR("(local)"));
		dbinit.AddProperty(DBPROP_INIT_LCID, (long) 1049 );
		dbinit.AddProperty(DBPROP_INIT_PROMPT, (short) 4 );
		hr = m_db.Open(_T("SQLOLEDB.1"), &dbinit);
		if (FAILED(hr))
			return hr;

		return m_session.Open(m_db);
}

HRESULT CmyData::fnWrite()      // Пытаюсь писать в БД
{
	CTable<CAccessor<CmyAccessor> > table;

	CDBPropSet	propset(DBPROPSET_ROWSET);
	propset.AddProperty(DBPROP_IRowsetChange, true);
	propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);
	table.Open(m_session, "myTable", &propset);
	table.m_column1 = val1;
	table.m_column2 = val2;
         ...

	return table.Insert();     // insert возвращает DB_E_ERRORSOCCURRED
}

class CmyTableAccessor
{
public:
	LONG m_column1;
	LONG m_column2;
	DBTIMESTAMP m_column3;

BEGIN_COLUMN_MAP(CmyTableAccessor)
	COLUMN_ENTRY( 1 , m_column1)
	COLUMN_ENTRY( 2 , m_column2)
	COLUMN_ENTRY( 3 , m_column3)
END_COLUMN_MAP()

	// You may wish to call this function if you are inserting a record and wish to
	// initialize all the fields, if you are not going to explicitly set all of them.
	void ClearRecord()
	{
		memset(this,  0 , sizeof(*this));
	}
};

INSERT INTO myTable (column1,column2,column3) VALUES (DEFAULT,<значение>,<значение даты/времени>)