How to insert Data to MS SQL from adobe interactive form?*urgent*

[Former Community Member]

Good afternoon!



I would like to ask how to insert to MS SQL from adobe interactive form?

What is the script for it and any website that provide sample form?



If you know read this and know the solution, please help me , my project due next week but i still unable to solve it.



thanks and i really appreciate to those who reply my post.....



thanks a lot

[Former Community Member]

Hi Weilin,

If not too late about the solution.

You can create a oledb data connection to sql server.

Select Microsoft OLEDB Provider for SQL Server, specify the server name and database name and create the SQL query for selection of data you want to insert.

After binding the data connection fields in your form you can add new records by script on a button click. xfa.sourceSet.DataConnection.addNew();



Hope helps,

Asiye

[MsPatil]

Hi,

I used SQL SERVER provider to connect to DAtabase but i get following error

"Connection for Source DataConnection failed because the environment is not trusted"

Any feedback on this is appriciated

Thanks