Writeback to mySQL database using IronPython

[Dony Unardi]

I was able to writeback data into SQL Server database using the following IronPython code:

import clr, datetime

clr.AddReference('System.Data')

from System.Data import SqlClient

sql = "INSERT INTO ...."

conn = SqlClient.SqlConnection("Server=ServerName;Database=DBName;UID=xxxxx;PWD=xxxxx)

conn.Open()

cmd = SqlClient.SqlCommand(sql, conn)

exe = cmd.ExecuteReader()

exe.Close()

conn.Close()

I am now trying to re-create this code formySQL5.7 database and having such a hard time.

I think mybiggest issue is with the mySQL connection string.

Would be great if someone could help me with a pointer for this.

Thank you in advance.

[Aleister Mraz]

This is precisely what I am trying to do as well.  Anyone have a solution at the ready