Jump to content

Failed to execute query for data source ""

Alberto Vinciguerra

Recommended Posts


this is myIronPython script where...

I'm connectin to my sql database (MariaDb) using odbc driver!

from Spotfire.Dxp.Data.Import import DatabaseDataSource

from Spotfire.Dxp.Data.Import import DatabaseDataSourceSettings

from Spotfire.Dxp.Application.Scripting import ScriptDefinition

from ........

import clr

connStr = "System.Data.Odbc"

dbConn = "driver=MySQL ODBC 8.0 Unicode Driver;Server=myserver;Database=mydb;UID=myUser;PWD=xyz;port=3306"

sqlCommand = "delete from mytable where Shift_Date = current_date()"

dbsettings = DatabaseDataSourceSettings(connStr, dbConn, sqlCommand)

ds = DatabaseDataSource(dbsettings)


newDataTable = Document.Data.Tables.Add("temp",ds)


Error is in:



Failed to execute data source query for data source "".


Link to comment
Share on other sites

  • 4 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...