Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Writeback to mySQL database using IronPython

Recommended Posts

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

import clr, datetime


from System.Data import SqlClient

sql = "INSERT INTO ...."

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


cmd = SqlClient.SqlCommand(sql, conn)

exe = cmd.ExecuteReader()



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.

Link to comment
Share on other sites

  • 1 year later...
  • Create New...