title: Connecting python3 on Ubuntu to SQL Server 2014
body: <p>I am trying to retrieve SQL data on a Linux Server (Ubuntu 16.04.2) in a Python 3.5 script using the ODBC Driver 13 for SQL Server. Running the script on SQL Server and Python in windows goes fine. Running the script in Python in Linux throws a SQL Server Syntax error:</p>
  
  <p>pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near '0x107c'. (102) (SQLExecDirectW)")</p>
  
  <p>As I add or remove columns it changes '0x107c' to a different character suggesting that it is not a single illegal character, but several. With a more limited amount of columns the script even runs (excluded [Order Type text] and [Order Nr]).This leads me to suspect something goes wrong in character set conversion. What am I doing wrong and how do I fix it? </p>
  
  <p>Python3.5:</p>
  
  <pre><code>import pandas as pd
  import pyodbc
  
  #Set parameters
  sql_file = 'file.sql'
  
  #Define methods
  def SQLDataToDataframe(filename):
      fd = open('file.sql','r')
      content = fd.read()
      fd.close()
  df = pd.read_sql(content, connection)
  return df
  
  #Import Data from SQL
  connection = pyodbc.connect('Driver={ODBC Driver 13 for SQL Server};'
                              'Server=Server;'
                              'Database=DB;'
                              'uid=User;pwd=Password')
  
   dataframe = SQLDataToDataframe(sql_file)
  </code></pre>
  
  <p>file.sql: </p>
  
  <pre><code>SELECT [ID]
    ,[Company Code]
    ,[Description]
    ,[Order Category]
    ,[Order Category Text]
    ,[Order Type]
    ,[Order Type text]
    ,[Order Nr]
  FROM [TABLE]
  </code></pre>