title: Passing Large XML data to xml datatype parameter in ADODB
body: <p>I have a procedure that takes a xml datatype parameter</p>
  
  <pre><code>create procedure my_procedure
      @xml_parameter xml
  as
  begin
  (...)
  end
  </code></pre>
  
  <p>And i call that procedure from a classic asp page, using a command like this: </p>
  
  <pre><code>set cmd = Server.CreateObject("ADODB.Command")        
  cmd.ActiveConnection = MyConnObj
  cmd.CommandText = "my_procedure"
  cmd.CommandType = adCmdStoredProc
  
  cmd.Parameters.Append cmd.CreateParameter("@xml_parameter", adLongVarChar, adParamInput, Len(xmlData), xmlData)
  </code></pre>
  
  <p>It's working if i pass a small xml. But when i pass a large xml, +- 200 Kb, I get the message "The procedure expects the @xml_parameter parameter, wich was not informed". </p>
  
  <p>Does anyone know how i can pass this xml to the stored procedure?</p>
  
  <p>PS: It also works when i call the procedure from "SQL Server Management Studio" with the same xml data, so it seems the limitation is from the ADO.</p>
  
  <h2>Edit in 2014-jun-19:</h2>
  
  <p>Debugging the problem i discovered a message from ODBC Driver saying that some data are being truncated. I tried to change the driver, by using "Driver={SQL Server Native Client 11.0}", but now i get the message : "The metadata could not be determined because statement (...) uses a temp table"</p>