Updating back Oracle Table From Spotfire Analysis - Issue With "DatabaseDataSourceSettings"

Hi,

I need to update the some of information from analysis back to table, Can you please correct if something wrong with the following script, As its give Exception.

 

dbsettings = DatabaseDataSourceSettings( "System.Data.OracleClient","Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.YYY.com)(PORT=1521))(CONNECT_DATA=(???)));User Id=User;Password=pwd",sqlStr)

 

Getting the following Exception:

Exception: Failed to execute data source query.

Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> System.InvalidOperationException: User input is need

(1) Answer

Login