Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

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

Avatar

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
2 Replies

Avatar

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

Avatar

Level 2

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