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

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.

Link to comment
Share on other sites

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