pyodbc.Error: ('HY000', 'The driver did not supply an error!')
<p>I have two Mysql connection via pyodbc declared as:</p>

<pre><code>connMy1 = pyodbc.connect('DRIVER={MySQL ODBC 5.3 Unicode Driver};SERVER=***;UID=***;PWD=***')
connMy1.autocommit = True
cursorMy1 = connMy1.cursor()

connMy2 = pyodbc.connect('DRIVER={MySQL ODBC 5.3 Unicode Driver};SERVER=***;UID=***;PWD=***')
connMy2.autocommit = True
cursorMy2 = connMy2.cursor()
</code></pre>

<p>I create a CSV with pandas caling the connection like this:</p>

<pre><code>def bajar(sql,tabla,ruta):
    print ("bajando datos")
    chunk = 10 ** 5 
    chunks = pandas.read_sql(sql, connMy1, chunksize=chunk)
    eliminarArchivo(ruta)
    print ("creando CSV")
    with open(ruta, 'w') as output:
        for n, df in enumerate(chunks):
            write_header = n == 0
            df.to_csv(output, sep=';', index=False, header=False, na_rep='NULL')
    connMy1.commit()   
</code></pre>

<p>Then I call this function to upload the CSV</p>

<pre><code>def subir(ruta,tabla):
    print ("Subiendo datos")
    sqlMy2 = "load data local infile '"+ruta+"' into table "+tabla+" fields terminated by ';' lines terminated by '\r\n';"
    print (sqlMy2)
    cursorMy2.execute(sqlMy2)
    connMy2.commit()
</code></pre>

<p>If I call the second function first (with a pre created CSV by the first function) it uploads the data perfectly, if I call the function after the first I get:
pyodbc.Error: ('HY000', 'The driver did not supply an error!')</p>

<p>Any hints of what Im doing wrong? 
Thank you!</p>