title: VB .NET Can Select on Linked Server but cannot update
body: <p>I've added a linked server by using Management Studio.</p>
  
  <p>In vb.net I can SELECT but I can't UPDATE</p>
  
  <p>I get a timeout error even if I set the timeout to 4 minutes.
  Here the code:</p>
  
  <pre><code>Dim cnx As New SqlClient.SqlConnection
  cnx.ConnectionString = "server=MY_LOCAL_SERVER;Trusted_Connection=yes;MultipleActiveResultSets=True"
  cnx.Open()
  
  ' This is working'
  Dim cmd As SqlCommand = cnx.CreateCommand
  cnx.CommandText = "SELECT * FROM [MY_LINKED_SERVER].[MYDB].[dbo].[MYTABLE]"
  Dim reader As SqlDataReader = cmd.ExecuteReader
  
  ' This is not working :( '
  cmd.CommandText = "UPDATE [MY_LINKED_SERVER].[MYDB].[dbo].[MYTABLE] SET Foo = @foo WHERE id = @id"
  cmd.Parameters.AddWithValue("@foo", "bar")
  cmd.Parameters.AddWithValue("@id", "10")
  cmd.CommandTimeout = 240
  cmd.ExecuteNonQuery() ' Timeout exception
  </code></pre>
  
  <p>If I execute this update query in Sql Management Studio it's working.</p>
  
  <p>EDIT: When i execute the query FROM SSMS it is very quick</p>
  
  <p>EDIT: INSERT or DELETE are working. Only UPDATE make a timeout error ...</p>
  
  <p>EDIT: It seems that if i'm not using Parameters in my update query, it's working, eg: "UPDATE ... SET Foo = 'bar'" will work while "UPDATE ... SET Foo = @foo" won't work Oo</p>