>Multiple instances of what?

The server? It sounds like you've already found the issue.

-Mike

>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