I created a form in LiveCycle Designer 8.2 that is connected to a SQL Server 2005 database. The database server I am connecting to is a network based server. Form has Move First, next, previous, move last, update, add, and cancel buttons. Used an OLEDB connection. When running the form on my workstation with Acrobat Pro, I can connect to the database and easily scroll through the records, add, delete, etc. When I access the form just through Adobe Reader 9.3, I can connect to the database - it displays the 1st database record on the form, but I can't scroll through the records or add and change records. The forms rights are extended. Question - does Acrobat Reader support database navigation and database update features? Any suggestions on what I may be missing / doing wrong. Thanks.
If your DB is on a server then I would suggest using a different methodology. Write a server side script to talk to the DB, then use regular HTTP submits to send and recieve data from the script. This is more work but it is much more reliable than the DB connection and will work regardless of Acrobat/Reader version or enabling.
Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]
The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]
Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]
The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/javascript.php]http://www.adobe.com/devnet/acrobat/javascript.php[/url]
Then most important JavaScript Development tool in Acrobat
[url=http://www.pdfscripting.com/public/34.cfm#JSIntro][b]The Console Window (Video tutorial)[/b][/url]
[url=http://www.acrobatusers.com/tutorials/2006/javascript_console][b]The Console Window(article)[/b][/url]
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script