Workflow Soluiton

 View Only
  • 1.  store record into database

    Posted Apr 22, 2013 10:17 PM

    I want to store a form to a database and it can be get back to revise, which components can do it ?

    How how can I the process status during the user submit a web Form ?

     



  • 2.  RE: store record into database

    Posted Apr 23, 2013 06:45 AM

    Quickest way to get data into and out of the database is use either SQL components (Logicbase.Components.SQL, not loaded by default) or the SQL generators. If you have a table already in a database to "hold" your data, you can just run the Table generator against that table to generate some stock components. If you need to get fancy, use the Query/Script generator to specify the exact SQL you want to use.



  • 3.  RE: store record into database

    Posted Apr 23, 2013 07:54 AM

    the error message occur , connection with server  successfully , the authorization fail.

    i set the data connection and set the id and password in connection string at integration .

     



  • 4.  RE: store record into database

    Posted Apr 23, 2013 11:30 PM

    error_0.jpg

    workflow2.jpg

     

    The connection String :data source=Altirispoc\sqlexpress;initial catalog=Symantec_CMDB;integrated security=SSPI;user id=Altirispoc\Administrator;password=Abcd1234

     

     

    The Password and ID is correct, but cannot pass the login pocess, what's wrong in my case ??

     



  • 5.  RE: store record into database
    Best Answer

    Posted Apr 24, 2013 07:27 AM

    Is your CMDB database set to accept remote connections? (I knew this was an issue way back in NS6, and you had to manually set this up to connect to the database)

    You can query that error for more info: a connection was successfully established with the server but then an error occurred during the login process

    See this post for some info

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/98e580dd-e12f-447f-9a0b-253b7be4d8e2/