title: How can I pass configuration variable values into the pyodbc connect command?
body: <p>I have a .ini (configuration file) where I have mentioned the server name, Database Name, UserName and Password with which I can connect my app to the MSSQL</p>
  <pre><code>self.db = pyodbc.connect(
      'driver={SQL Server};server=homeserver;database=testdb;uid=home;pwd=1234')`
  </code></pre>
  <p>corresponding data mentioned above connect statement is now in config.ini</p>
  <pre><code>self.configwrite = ConfigParser.RawConfigParser()
  configread = SafeConfigParser()
  configread.read('config.ini')
  
  driver = configread.get('DataBase Settings','Driver')
  server = str(configread.get('DataBase Settings','Server'))
  db = str(configread.get('DataBase Settings','Database'))
  user = str(configread.get('DataBase Settings','Username'))
  password = str(configread.get('DataBase Settings','Password'))'
  </code></pre>
  <p>How can I pass these variables in the pyodbc connect statement?</p>
  <p>I tried this:</p>
  <pre><code>self.db = pyodbc.connect('driver={Driver};server=server;database=db;uid=user;pwd=password')
  </code></pre>
  <p>But I am getting an error.</p>