Connecting SQL server from Adobe forms

[Former Member]

Hi Experts,

I want to know, whether it is possible to connect SQL Server database from Adobe Form directly at runtime without WAS/ADS. If it is possible, please provide any material to proceed further.

Please help.

Thanks,

Rajee

[marcel_frei]

Have a look at the following document, it explains how to use a MS Access database but it should also work when using a ODBC Data source configured for a MS SQL database.

[Providing interactive database lookup from forms|http://www.adobe.com/devnet/livecycle/articles/lc_designer_db_lookup_tip.pdf]

I hope I could help you.

[Former Member]

Hello Marcel Frei,

Thanks a lot for your help. But in this arcticle Adobe Acrobat Professional is used, is it possible to get DB values in Adobe Reader?

Please help.

Thanks,

Rajee

[marcel_frei]

Hi Ranjee,

I have to admit that I haven't tried it. We are using adobe forms together with WebDynpro for Java, I haven't tried any other data sources yet.

Marcel