title: Trying to pass a value from VBA to sql stored proc, getting improperly defined error
body: <p>Just trying to pass a 5-letter string value (ie, "SSIID") from my VBA project to a parameter in my sql stored procedure but apparently I'm mixing up the types or something is going wrong. The error is:</p>
  
  <blockquote>
    <p>Parameter object is improperly defined.</p>
  </blockquote>
  
  <p>I've looked up the comparable data types here <a href="http://www.w3schools.com/ado/ado_datatypes.asp" rel="nofollow">http://www.w3schools.com/ado/ado_datatypes.asp</a> and tried to match but to no avail. Any ideas?</p>
  
  <p><strong>VBA</strong></p>
  
  <pre><code>.CreateParameter("@Location", adVarChar, adParamInput, , "SSIID")
  </code></pre>
  
  <p><strong>SQL Parameter</strong></p>
  
  <pre><code>@Location varchar
  </code></pre>