Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

store record into database

Created: 22 Apr 2013 • Updated: 09 May 2013 | 4 comments
Candyip's picture
This issue has been solved. See solution.

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 ?

Operating Systems:

Comments 4 CommentsJump to latest comment

reecardo's picture

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.

Candyip's picture

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 .

Candyip's picture

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 ??

reecardo's picture

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/sqld...

SOLUTION