I am trying to get an SQL Table into a Pandas DataFrame and get a cursor error

[alan28a]

I am just trying to get an SQL Server table into a Pandas DataFrame and copied this code from the internet, obviously added my local details and credentials ie XXXX etc. Which I think works OK. When I try to run the next bit I get the messages below.

As a newbee please can someone help me as I have been going round in circles for 3 hours now!!!!! Many thanks

import pyodbc
import pandas as pd
 
conn = pyodbc.connect
(r'DRIVER={ODBC Driver 13 for SQL Server};' +
 ('SERVER={server},{port};'   +
  'DATABASE={database};'      +
  'UID={username};'           +
  'PWD={password}').format(
                server= 'XXXXXX',
                  port= 'XXXXXX',
              database= 'XXXXXXX',
              username= 'XXXXXXX',
              password= 'XXXXXXXXX'))
 
SQL = "select [PASID], [TeamReferralStartDate], [TeamReferralEndDate], ]TeamCodeDescription] FROM live.tbl_ref_Mart"
 
SQL_Query = pd.read_sql_query (SQL ,conn)

Above code gives me

  File "<ipython-input-68-57057e3d73eb>", line 3, in <module>
    SQL_Query = pd.read_sql_query (SQL ,conn)
 
  File "C:\Users\SMITHAL\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\io\sql.py", line 332, in read_sql_query
    chunksize=chunksize,
 
  File "C:\Users\SMITHAL\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\io\sql.py", line 1645, in read_query
    cursor = self.execute(*args)
 
  File "C:\Users\SMITHAL\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas\io\sql.py", line 1590, in execute
    cur = self.con.cursor()
 
AttributeError: 'builtin_function_or_method' object has no attribute 'cursor'