title: MS SQL Invalid Object Name
body: <p>I have</p>
  
  <pre><code>cursor.execute("select RM_ID FROM Sales.dbo.MARKETING where VERSION = 'SomeVersion'")
  </code></pre>
  
  <p>which gives me the traceback error:</p>
  
  <pre><code>pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Sales.dbo.MARKETING'. (208) (SQLExecDirectW)")
  </code></pre>
  
  <p>I have several other lines of code:</p>
  
  <pre><code>cursor.execute("select RUNDATEEST FROM Sales.dbo.MARKETING where VERSION = 'SomeVersion'")
  </code></pre>
  
  <p>that are exactly the same except for the column name that give me no error. I'm not sure what my mistake is.</p>
  
  <p><strong>Of note:</strong></p>
  
  <ul>
  <li>I have already checked the table for the column name to make sure it exists.</li>
  <li>I have noticed that this column is the key for this table.  Perhaps a different syntax is required for keys?</li>
  <li>When I execute the query in SQL Server, it runs just fine.</li>
  </ul>