title: insert data into MSSQL server using python
body: <p>I am trying to insert data to the sql server table using following code,</p>
  
  <pre><code>import pyodbc
  user='sa'
  password='PC#1234'
  database='climate'
  port='1433'
  TDS_Version='8.0'
  server='192.168.1.103'
  driver='FreeTDS'
  
     con_string='UID=%s;PWD=%s;DATABASE=%s;PORT=%s;TDS=%s;SERVER=%s;driver=%s' % (user,password, database,port,TDS_Version,server,driver)
     cnxn=pyodbc.connect(con_string)
     cursor=cnxn.cursor()
     cursor.execute("INSERT INTO mytable(name,address) VALUES (%s,%s)",('thavasi','mumbai'))
     cnxn.commit()
  </code></pre>
  
  <p>Its giving me the following error while executing,</p>
  
  <pre><code>   Traceback (most recent call last):
    File "sql.py", line 26, in &lt;module&gt;
    cursor.execute("INSERT INTO mytable(name,address) VALUES (%s,%s)",('thavasi','mumbai'))
   pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 2 parameters were supplied', 'HY000')
  </code></pre>
  
  <p>I have checked the syntax for the insert statement its correct. So what causes this error?</p>