Mike,
Multiple instances of what?
Thanks,
Terry
>Terry,
>
>How do you "put 10 clients messaging with the server?" Are you sure that you're not getting into multiple instances here?
>
>-Mike
>
>>To All,
>>
>>Happy Thanksgiving.
>>
>>I really hope someone has seen this occur before, since I really do not know what to do here.
>>
>>I have a tcp/ip server program that I've tested extensibly, and if I put a breakpoint at 119 it will never be hit unless I put 10 clients messaging with the server. Then there is a problem almost immediately. The problem is that under this high load of 10 clients hitting the server every 1/2 second:
>>line 107 shows me that dalrequest.command = "pr_step_updatecompleteness"
>>, but
>>ocmd.commandtext = "pr_step_selectlast"
>>This doesn't make sense that ocmd.commandtext could change between lines
>>107 and 116, and I can't even find a way to trace since it only happens Rarely.
>>
>>This is bad because we will have the wrong number of parameters, and we are executing a query with a nonquery.
>>e.message = "Too many arguments specified for pr_step_selectlast"
>>pr_step_selectlast expects one input and pr_step_updatecompleteness expects two inputs.
>>pr_step_selectlast was the last stored procedure run, so why is it getting confused with the current stored procedure = pr_step_update completeness?
>>
>>On a different run it will confuse two other consecutive SPs similarly, with maybe an update trying to be run inside a dataadapter fill routine.
>>
>>This confusion has never happened to me except in this one server many clients = 10 context.
>>
>>Does anyone know what is happening here and how to avoid it? I need about 100 clients to work here.
>>
>>Thanks,
>>
>>100 Public Overloads Overrides Sub Execute()
>>101 Dim oCmd As SqlCommand = New SqlCommand()
>>102 Dim oEnumerator As IEnumerator = m_oParmList.GetEnumerator()
>>103 Try
>>104 Me.Connection.ConSql.Open()
>>105 With oCmd
>>106 .Connection = Me.Connection.ConSql
>>107 .CommandText = DalRequest.Command
>>108 .CommandType = DalRequest.CommandType
>>109 End With
>>110 If DalRequest.CommandType = CommandType.StoredProcedure Then
>>111 Do While (oEnumerator.MoveNext())
>>112 Dim oP As Parameter = oEnumerator.Current
>>113 oCmd.Parameters.Add(ConvertParameterToSqlParameter(oP))
>>114 Loop
>>115 End If
>>116 oCmd.ExecuteNonQuery()
>>117 Catch e As SqlException
>>118 dim error as string = e.message
>>119 dim x as string = "nothing but a convenient breakpoint line"
>>120 Finally
>>121 Me.Connection.ConSql.Close()
>>122 End Try
>>123 End Sub