populate drop down with latest data from database and save

[Berry]

Hi folks,

I am using acrobat professional 8 suit to design form and save the
pdfs.

I have live cycle designer and dabase sql server to populate combobox
in pdf forms.

once i save it as pdf and end-user would like to see the latest data
from database in combobox.

I am nt able to get latest data(updated). please help.wat ohter adobe
product wil be recquired to save pdf data in database.

thanks in advance.

regards

Berry

[came...@gmail.com]

Hi Berry -

It seems that you want to prepopulate the form and if this is the case
you may need to buy livecycle forms server. If you are just trying to
submit the data back to your sql database, there are a bunch of
options. Please clarify what you are trying to do.

Liz

[Berry]

thnks for reply,

I have to do both prepopulate the form as well as submit the data back
to your sql database in windows application.
i hav limitations to use acrobat profession 8 suite that has live
cycle designer for design form.

all is done ,except the prepopulate the form..
pls tell me a gud approach. I hav done this thing using data
connection in adobe designer.
but it has overhead of creating DSN for database manually for each
user.

can it be done programmitically(creating DSN using sql server
authentication)?

thnks

On May 29, 11:51 pm, "camemb...@gmail.com" <camemb...@gmail.com>
wrote:

> > Berry- Hide quoted text -
>
> - Show quoted text -

[came...@gmail.com]

I apologize but I'm not too familiar with DSN so I can't speak towards
that solution. However, you can load from xml if you have a xml file
that you can get at via javascript. The only caveat is that it has to
be user initiated (because its a javscript event).

Our company poured over trying different ways to prepop without forms
server but nothing worked like we wanted so we were strongholded into
buying it.

Are you using livecycle for this? I'm not sure whats standard, but do
you have the PDFForm QPAC?

Liz

[Berry]

Hi,
I need help in saving Pdf form fill in data in sqlserver that is
designed in live cycle designer.

I am working on desktop application. Once the data is saved i should
be able to load the pdf with saved data from database,

pls suggest me possible approaches.

I can save data in database, but can't open the pdf with saved data.

thnks

[Zee Yang]

Hi Berry, there are few alternative for processing forms,

* if all your users have license for acrobat std or pro, you could
build forms that access web services or databases directly. no back
end is needed. here are a few tutorials from Stefan Cameron that could
help you get started, http://forms.stefcameron.com/category/data-binding
* if all your users are using reader, you can build a simple
server side solution using the XPAAJ library. here is a tutorial I
made on XPAAJ, http://www.flexlive.net/?p=37
* if you need to scale up your solution over time, it would make
sense to invest in the Forms ES.

HTH
-Zee