title: SSL connection error: SSL certificate validation failure (2026) (SQLDriverConnect) pyodbc?
body: <p>I am trying to connect to Azure MySQL Database Service. I am using</p>
  <blockquote>
  <p>pyodbc==3.0.3</p>
  <p>python 2.7</p>
  </blockquote>
  <p>My Connection string looks like this</p>
  <pre><code>connection_string = &quot;DRIVER={MySQL};SERVER={server_name}.mysql.database.azure.com;PORT=3306;DATABASE&quot; \
                          &quot;={my_database_name};UID={username@server_name};PWD={password};CHARSET=UTF8;&quot; \
                        &quot;sslca=/home/sachin/BaltimoreCyberTrustRoot.crt.pem;sslverify=1&quot;
  cnxn = pyodbc.connect(connection_string)
  </code></pre>
  <p>But the same configuration works with mymysql.connector is working fine.</p>
  <pre><code>import mysql.connector
  
  cnx = mysql.connector.connect(user=&quot;{username@servername}&quot;, password=&quot;{password}&quot;,
                                host=&quot;{server_name}.mysql.database.azure.com&quot;,
                                port=3306, database=&quot;{database_name}&quot;, ssl_ca=&quot;/home/sachin//root.crt&quot;,
                                ssl_verify_cert=True)
  cnx.cursor()
  </code></pre>
  <p>I can not use mysql.connector for now. So need some suggestion if any one have faced this issue.</p>