title: python pyodbc SQL Server Native Client 11.0 cannot return geometry column
body: <p>I have SQL Server Native Client 11.0 and pyodbc installed using python 2.7. I am able to set the connection correctly within python </p>
  
  <pre><code>import pyodbc
  conn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0};SERVER=b;DATABASE=b;UID=b;PWD=b')
  cur=conn.cursor()
  query=cur.execute('''select top 1 * from table''')
  for x in query.fetchall():
      print x
  
  Traceback (most recent call last):
    File "&lt;module1&gt;", line 8, in &lt;module&gt;
  ProgrammingError: ('ODBC SQL type -151 is not yet supported.  column-index=40  type=-151', 'HY106')
  </code></pre>
  
  <p>if i do, i get the same error</p>
  
  <pre><code>for x in query:
     print x
  </code></pre>
  
  <p>how do I return the query? </p>
  
  <p>if I just print query I get <code>pyodbc.Cursor object at 0x02B74AD8</code></p>
  
  <p>could it be column type it cannot read, there is a point geometry in this table. </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>the problem is with the point geometry. when I take out the geometry I can return what the cursor contains. however when the geometry column is in there it always throughs this error. I am assuming the pyodbc does not have support for geometric objects... as a work around I can convert to WKT</p>