ERROR_SXS_KEY_NOT_FOUND- Automation fails in CreateThread

From:

=?Utf-8?B?c3VkaGFrYXI=?= <sudhakar@discussions.microsoft.com>

Newsgroups:

microsoft.public.vc.mfc

Date:

Mon, 8 Sep 2008 22:58:01 -0700

Message-ID:

<708690A1-A847-4F71-88B7-2E0A68FD79F1@microsoft.com>

Hello ,

I created a MFC Dialog based application and then using class wizard created
Automation classes for excel.

I'm able to call the Automation object using the function CreateDispatch
function and it starts the excel.exe. This is fine. Code is below

void OnRun()
{

    COleException *excp = new COleException;
    CString s , err;
    s.Empty();
    //GetDlgItem(IDC_APPEDIT)->GetWindowText(s);
          // Start Excel and get Application object...Excel.Application
         if( app.CreateDispatch("Excel.Application" , excp) == FALSE )
         {
            err.Empty();
            err.Format(" Error: %d",GetLastError());
            AfxMessageBox(err);
         }
         else
         {
            //Make Excel Visible and display a message
          app.SetVisible(TRUE);
        err.Empty();
          err.Format("%s is Running!!",s);
          AfxMessageBox (err);

}

But the same part of the above code , if it is being called from
CreateThread like the below code, , it returns error code 14007

    DWORD dwThreadId;
    HANDLE hThread =
CreateThread(0,0,DIAdemInstanceThread,(LPVOID)this,0,&dwThreadId);

DWORD WINAPI DIAdemInstanceThread(LPVOID lpParam)
{
    _Application app;
    COleException *excp = new COleException;
    CString s , err;
    s.Empty();
         // Start Excel and get Application object...Excel.Application
         if( app.CreateDispatch("Excel.Application" , excp) == FALSE )
         {
            err.Empty();
            err.Format(" Error: %d",GetLastError());
            AfxMessageBox(err);
         }
         else
         {
            //Make Excel Visible and display a message
          app.SetVisible(TRUE);
        err.Empty();
          err.Format("%s is Running!!",s);
          AfxMessageBox (err);
         }

    return 0;
}
Details of the Win32 Error code;
**********************************
14007 - ERROR_SXS_KEY_NOT_FOUND

Description:
************
The requested lookup key was not found in any active activation context

why is this happening ? Please help me out.

thanks ,
Sudhakar