Ciao,

Basta fare un cast a LPCSTR:

codice:
	BSTR* ticketReturn = (BSTR*)"No data available"; 
	CString resCStr;
 
	if (ticketReturn != NULL)
	{
		CString resStr = (LPCSTR)ticketReturn;	
		AfxMessageBox(resStr);
	}