title: python pyodbc : how to connect to a specific instance
body: <p>Am trying to connect to a specific instance of SQL Server and get some data from system tables. Am connecting using this code snippet:</p>
  
  <pre><code>connSqlServer = pyodbc.connect('DRIVER={SQL Server Native Client 10.0};SERVER=192.106.0.102;DATABASE=master;INSTANCE=instance1;UID=sql2008;PWD=password123;Trusted_Connection=yes')
  ...
  cursorObj.execute("select * from sys.dm_os_sys_info")
  row = cursorObj.fetchone()
  print("rows from table ",row) 
  </code></pre>
  
  <p>however am getting the values for the default instance only, but not able to get the value for 'instance1'. So, giving instance name in 'INSTANCE=instance1' really seems to have no effect. Even without it (tried giving 'PORT=1443', the instance's port number), am getting the values only for the default SQL Server instance. How to force it to get the values for the specific instance?</p>