Failed to execute query for data source ""

[Alberto Vinciguerra]

Hello,

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)

Document.Data.Tables.Remove(newDataTable)

Error is in:

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

-------------------

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

----------------------------

[Tutika Vaibhav Sai Thirumalesh]

Hi Were you able to resolve this issue ?

[Alberto Vinciguerra]

Hello, I solved (without suggestions) in june, my error changing the dbConn connection string.

[Tutika Vaibhav Sai Thirumalesh]

i am using SQL DB and facing the same issue

any suggestions please.

[Alberto Vinciguerra]

this is the old connection string:

connStr = "System.Data.Odbc"

that is my new connection string. It works fine...

connStr = "System.Data.odbc"

odbc is lower case

No more changes in my code!

[Tutika Vaibhav Sai Thirumalesh]

Thank You.