C / C++ / MFC

I have Done all the Settings to run the Unicode Program
    1. Added "_UNICODE" in Preprocessor Directives and removes "_MBCS"
    2. Entrypoint in Link tab as "wWinMainCRTStartup"

<code>
	CDatabase cn;
	CString FieldValue1,FieldValue2,FieldValue3;
	CDBVariant varvalue;

	CString csPwd,csUser,csServer,csDBName;
	csPwd = "SQLServer2005";
	csUser = "sa";
	csDBName = "DeccanCollege";
	csServer = "DECCANSERVER";

	cn.OpenEx(_T("DRIVER={SQL Server};Pwd="+csPwd+";Uid="+csUser +";Database="+csDBName+";Server="+csServer),CDatabase::noOdbcDialog);

	TCHAR *m_Voc = (TCHAR*) malloc(50); //allocate memory
        m_VocEdit.GetWindowText(m_Voc,50);     // get Edit box Unicode Value

//Suggest How to Pass "m_Voc" value as Unicode
	CString sqlStr = _T("Select * from Vocablemaster where slvid in(Select slvid from slipvocmaster where binno between 165 and 169) and (VocDescSan like N'%"+CString(m_Voc)+"%')");
	CRecordset rec(&cn);
	rec.Open(CRecordset::forwardOnly,sqlStr,CRecordset::none);

   while(!rec.IsEOF()) 
	{
		rec.GetFieldValue((short)0,FieldValue1);
		rec.GetFieldValue((short)1,FieldValue2);
		rec.GetFieldValue((short)2,FieldValue3); 
		rec.MoveNext();
	}
</code>

<code>
  HRESULT hr;
  CoInitialize(NULL);
  try
  {
	  ADODB::_ConnectionPtr connection;
	  hr = connection.CreateInstance(__uuidof(ADODB::Connection));
	  if (FAILED(hr))
	  {
		  throw _com_error(hr);
	  }
	  ADODB::_RecordsetPtr recordset;
	  hr = recordset.CreateInstance(__uuidof(ADODB::Recordset));
	  if (FAILED(hr))
	  {
		  throw _com_error(hr);
	  }
	  connection->CursorLocation = ADODB::adUseClient;
	  connection->Open(L"Provider=sqloledb;Data Source=DECCANSERVER;"
		L"Initial Catalog=DeccanCollege;User Id=sa;Password=SQLServer2005;", L"",
		L"", ADODB::adConnectUnspecified);

	  TCHAR *m_Voc = (TCHAR*) malloc(50); //allocate memory
        m_VocEdit.GetWindowText(m_Voc,50);     // get Edit box Unicode Value

        _variant_t varVoc = m_Voc;
//Suggest How to Pass "m_Voc" value as Unicode
	  recordset->Open(L"SELECT * from VocableMaster where VocNo like  N'%"+_bstr_t(varVoc.bstrVal)+"%'",  connection.GetInterfacePtr(),
			ADODB::adOpenForwardOnly, ADODB::adLockReadOnly,  ADODB::adCmdText);
	  while(!recordset->ADOEOF)	 
	  {
		  _variant_t var;
		  var = recordset->Fields->GetItem(L"VocDescSan")->GetValue();
		  std::cout << static_cast<char *>(_bstr_t(var.bstrVal))
			<< std::endl;
			  recordset->MoveNext();
	  };
	  recordset->Close();	  
  }
  catch(_com_error &e)
  {
	  //std::cerr << ::outputashex(hr) << ":"
	  std::cerr << static_cast<char *>(e.Description());
  }
  catch(...)
  {
	  std::cerr << "Unhandled Exception";
  };

</code>