Hi all, <BR><BR>I&#039;m trying to retrieve the output parms from a simple Select stored procedure, but I get nothing back at all. If I do a straight Command.execute, then I get the param back, but not if I set the recordset to the Command.execute. <BR><BR>I have tried using Set NoCount On in the stored proc, setting CursorLocation = adUseClient, etc, but still no luck. Connection is using OleDb. <BR>ASP code is below:- <BR><BR>set cmdCampaigns = Server.CreateObject("ADODB.Command") <BR>set recCampaigns = Server.CreateObject("ADODB.Recordset") <BR>Set objADOConnection = Server.CreateObject("ADODB.Connection") <BR> <BR>objADOConnection.Provider = Application("SQLServerProvider") <BR>objADOConnection.Properties("Data Source") = Application("SQLServerDataSource") <BR>objADOConnection.Properties("Initial Catalog") = Application("SQLServerInitialCatalog") <BR>objADOConnection.Properties("Integrated Security") = Application("SQLServerIntegratedSecurity") <BR><BR>objADOConnection.CursorLocation = adUseClient <BR>objADOConnection.Open <BR>set cmdCampaigns.ActiveConnection = objADOConnection <BR><BR>cmdCampaigns.CommandText = "GET_USER_CAMPAIGNS" <BR>cmdCampaigns.CommandType = adCmdStoredProc <BR><BR>cmdCampaigns.Parameters.Append cmdCampaigns.CreateParameter(, adInteger, adParamReturnValue) <BR>cmdCampaigns.Parameters.Append cmdCampaigns.CreateParameter("@NT_USERID", adVarchar, adParamInput, 30, strUserName) <BR>cmdCampaigns.Parameters.Append cmdCampaigns.CreateParameter("@CLIENT_ID", adInteger, adParamInput, , intClientId) <BR>cmdCampaigns.Parameters.Append cmdCampaigns.CreateParameter("@RETURNCODE", adInteger, adParamOutput) <BR><BR>recCampaigns.CursorLocation = adUseClient <BR><BR>&#039;If I use the excute below, everything works <BR>&#039;cmdCampaigns.Execute() <BR>&#039;If I use the following, it doesn&#039;t <BR>&#039;recCampaigns.Open cmdCampaigns, , adOpenStatic, adLockReadOnly <BR>&#039;Also tried it this way <BR>&#039;Set recCampaigns = cmdCampaigns.Execute() <BR>Response.Write "// RC = " & cmdCampaigns.Parameters("@RETURNCODE").Value & " - " & cmdCampaigns.Parameters(3).Value & " - " & cmdCampaigns.Parameters(0).Value & vbCRLF <BR><BR><BR>The Stored Proc is a straight Select From, with Set NoCount On at the beginning. <BR><BR>Anyone got any ideas? as i&#039;m completely stuck now. <BR><BR>Many thanks <BR><BR>Andy