Data Access :: Executing Stored Procedure From Excel VBA Seems To Lose Connection In Middle Of Sproc Execution

I am running into an issue while executing a sproc from Excel VBA.  Everything connects fine, and I am passing a parameter, however, after a few seconds, it seems like the connection receives a "completed" command and continues down it's code, but the sproc is still executing.  The result is that I never receive the record set from the sproc.Here is the code snippet from VBA:

' Create Recordset objects.
Dim cmd As New ADODB.Command
Dim conn As ADODB.Connection
Dim prm As ADODB.Parameter
Dim sConnString As String
Dim rs As ADODB.Recordset
Dim strQry As String
Dim rowCount As Long

[code]....

And here is the sproc that is being called. the first thing it performs after the "IF" block (there are multiple steps that would consecutively be called after this, but all of the data hinges on this first step working) is a TRUNCATE statement.  After running a SQL profiler while executing the VBA code, I consistently see an "account log out" entry; almost as if the connection from the Excel workbook is sent a disconnect instruction.  The sproc continues to run and perform the rest of the script in the "IF" block, but the returned recordset is never returned back to Excel.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET NOCOUNT ON
GO

[code]....