Hi.
How to retrieve job information from Robot schedule (https://www.helpsystems.com/products/job-scheduling-software-ibm-i ) and utilize that as a web page in ASP.NET for end users ?
I have tried the below code, but getting error:
private void IseriesConnect()
{
int count = 0;
using (iDB2Connection conn = new iDB2Connection(ConfigurationManager.ConnectionStrings["IbmIConnectionString"].ConnectionString))
{
string sqlStatement = "SQL statement" ;
iDB2Command cmd = new iDB2Command(sqlStatement, conn);
cmd.CommandType = CommandType.Text;
conn.Open();
count = (Int32)cmd.ExecuteScalar();
conn.Close();
}
}
In the web.config
<add name="IbmIConnectionString" connectionString="DataSource=servername;DefaultCollection=ROBO;User Id=username;Password=pwd;"/>
Error:
Message : The ConnectionString property is invalid.
MessageDetails : UserID
I have tried : UID, User Name, UserName, UserID, User ID - but same error
Is there a way to read this data ?
Thanks