Connecting LiveCycle ES 8.2 Form to SQL Server 2005

[Former Community Member]

Hey All,

I searched this forum and others to make sure this question wasn't asked, but I wasn't able to find any.  I was wondering if anybody knew a great resource to use, kind of like a step by step process of connecting a LiveCycle PDF form that will insert and update a record into an SQL Server 2005 Database.  I was actually able to find one resource entitled, "Creating Dynamic Forms with Adobe LiveCycle Designer" by JP Terry, I ordered it through eBooks, but it doesnt seem to answer this question.  If someone could point me into this direction it would be great appreciated.

Happy Holidays,

Paddy

[Niall_O_Donovan]

Hi,

Stefan Cameron has some great examples on his blog, which are well worth a look at. In particular the comments which contain further questions and detailed responses.

http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/

http://forms.stefcameron.com/2007/03/07/adbc-now-disabled-by-default/

http://forms.stefcameron.com/2006/10/12/displaying-all-records-from-an-odbc-data-connection/

John Brinkman also has some data binding examples on http://blogs.adobe.com/formfeed/.

Hope that helps,

Niall