question

PadmanabhanVenkatesh-6789 avatar image
0 Votes"
PadmanabhanVenkatesh-6789 asked TimonYang-MSFT edited

Read Robot schedule information

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

not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PadmanabhanVenkatesh-6789
Robot schedule is a third-party product, and Microsoft Q&A does not provide support for it temporarily.
Moreover, if they allow users to read data from the outside world, they should provide the corresponding API and technical documentation, so it may be more appropriate to ask the provider of this product.

1 Vote 1 ·

0 Answers