Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Not applicable
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

Not applicable
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