class ATL_NO_VTABLE CMyDatabase : 
	public CComObjectRootEx<CComMultiThreadModel>,
	public CComCoClass<CMyDatabase, &CLSID_MyDatabase>,
	public IObjectControl,
	public IMyDatabase

STDMETHODIMP CMyDatabase::OpenConnection(BSTR ConnectionString, BSTR UID, BSTR PWD, long Options)
{

	HRESULT hr = m_connection.CreateInstance(__uuidof(Connection));
	if (SUCCEEDED(hr))
		hr = m_connection->Open(ConnectionString, UID, PWD, Options);
	if (SUCCEEDED(hr))
		hr = m_command.CreateInstance(__uuidof(Command));
	if (SUCCEEDED(hr))
		hr = m_command->putref_ActiveConnection(m_connection);
	if (SUCCEEDED(hr))
		hr = m_recordset.CreateInstance(__uuidof(Recordset));

	AddRef(); //счетчик доб

	return hr;
}

STDMETHODIMP CMyDatabase::LogOut()
{
	m_recordset->Close();
	m_connection->Close();
	Release(); //счетчик убав
	return S_OK;
}

void CClientDlg::OnConnect() 
{
	CLSID clsid;
	HRESULT hr;

	UpdateData();

	hr = AfxGetClassIDFromString(m_progid, &clsid);
	if (FAILED(hr))
	{
		MessageBox("Could not get class id");
		return;
	}

	 COSERVERINFO serverinfo;
	 COSERVERINFO* pServerInfo;
	 DWORD dwContext;

	 MULTI_QI qi[1] = {				
						{&IID_IMyDatabase, NULL, 0}
	 };
	 	 
	 if (m_nLocalRemote == 0)
	 {
		 pServerInfo = NULL;
		 dwContext = CLSCTX_LOCAL_SERVER; 
	 }
	 else 
	 {
		serverinfo.dwReserved1 = 0;
		serverinfo.dwReserved2 = 0;
		serverinfo.pwszName = m_strServer.AllocSysString();
		serverinfo.pAuthInfo = NULL;
		pServerInfo = &serverinfo;
		dwContext = CLSCTX_REMOTE_SERVER;
	 }

	 hr = CoCreateInstanceEx(clsid, NULL, dwContext, 
		                     pServerInfo, 1, qi);
	
	if (SUCCEEDED(hr))
	{
		m_pDatabase = (IMyDatabase* )qi[0].pItf;



		
		MessageBox("Соединение ОК.", "OnConnect");

	}
	else
		MessageBox("не смог соедениться.", "OnConnect");	
}

void CClientDlg::OnBtnLogon() 
{
HRESULT hr;
UpdateData();
CString	strServer = _T("Driver={SQL Server};Server=TEST\\TEST;"  "Trusted_Connection=no;" "Database=ATMServer1;Uid="+m_strUsrName+";Pwd="+m_strPwd+";");
hr = m_pDatabase->OpenConnection(strServer.AllocSysString(),m_strUsrName.AllocSysString(),m_strPwd.AllocSysString(),0);
		if (SUCCEEDED(hr))
	{
		
		MessageBox("Вошел на SQL.", "Login");

	}
	else
		MessageBox("Не вошел.", "Login");		
}	

void CClientDlg::OnBtnLogout() 
{
	// TODO: Add your control notification handler code here
	m_pDatabase->LogOut();

}