title: ADODB.connection open returning application defined or object defined error
body: <p>I have the below code and it is returning an error:</p>
  
  <blockquote>
    <p>Application defined or object defined error.</p>
  </blockquote>
  
  <pre><code>Public Sub TestConnection()
      Dim conn
      Set conn = New ADODB.connection
      CONSTRING = "Provider=NZOLEDB;Data Source=location;Initial Catalog=database;User ID=username; Password=password;"
      conn.Open CONSTRING
  
  End Sub
  </code></pre>
  
  <p>Any idea why this is happening? I am not substituting the variables etc. just typing them directly into the string.</p>