?
Solved

How complicated is it to use Adobe LiveCycle to create interactive forms with a SQL server database?

Posted on 2012-03-11
8
Medium Priority
?
669 Views
Last Modified: 2012-03-12
I am planning to hire a freelance form designer in livecycle to create a series of forms for me.

These forms need to be interactive with a SQL server database.  

Does the designer need to have SQL experience or is that something I can work with her on?  I am very proficient with SQL server but have never used LiveCycle!

Thanks for you input!
0
Comment
Question by:lthames
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 37709627
As always, it depends :)

You need some level of SQL background to create forms that interact with a DB, but the system does take some load off your back by providing methods that can do work for you that you would have to do yourself with a less sophisticated system. It all depends on what exactly it is you want the form to do.

Take a look at this article that gives a brief introduction about how to connect a form to a DB. As you can see, there is not much SQL involved, but the form is very simple. As soon as you are doing joins, it gets more complicated and your form designer may need a bit more SQL background. You can always try to do the heavy SQL lifting for the designer, but in my experience it's best if the forms designer has that background.

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

Author Comment

by:lthames
ID: 37709693
Great,  Thanks!  I will read that article this morning.

I started doing some reading last night and was having a hard time figuring out if the entire lifecycle suite was required to write to a SQL database or if just the lifecycle desiner would do.  Do I need to install the entire thing?

Again, Thanks!
0
 
LVL 44

Accepted Solution

by:
Karl Heinz Kremer earned 2000 total points
ID: 37709740
Lifecycle Designer will let you create forms that can access a database. You do not need anything else. Adobe unfortunately has this "Livecycle" range of products that do all sorts of things, and that causes quite a bit of confusion. Most of the Livecycle products are for the server, Designer is a - even though it's tied to the server products by name - client level product.

If you want to get more into how this all works, I can recommend a book that even though a few years old, still is a good resource to understand XFA forms:
Creating Dynamic Forms with Adobe® LiveCycle® Designer by J. P. Terry
0
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 

Author Comment

by:lthames
ID: 37709864
I read the article and understand the process. . . very similar to Access forms in logic.  

I am really confused about the range of products . . . I guess I do need to buy the book so I can wrap my head around it . . . . but I am trying to hire someone who can do the project because I am limited on time.   I am in the process of installing LiveCycle (which is how I figured out that I need to install alot more than just the designer).

I use my development PC as a SQL server for development and was installing LiveCycle ES2 and the other components on my PC for that reason.  

I am assuming that in the live environment LiveCycle ES2 will be required on their SQL server?  Or is that a server for handling form applications and not required JUST to use designer to make forms that will connect to a SQL server?

Are you for hire?
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 37709933
For just a form that talks to a SQL database, all you need is Designer.

I assume that you are planning on only using the form in-house, otherwise you would have to expose your database through the firewall. The LC server products do provide support - among other things - for DB access on the Internet, but that's not an area that I am too familiar with.

As far as your last question goes: EE does not permit discussions about contracts off the EE site. You can look at my profile to find out more about what I do and how to contact me.
0
 

Author Comment

by:lthames
ID: 37709989
This form will be used on Ipads in the field and connect to a hosted SQL server.  But I've got that covered, assuming Adobe doesn't limit the ability to access SQL server by IP address.

I'm going to be testing that on a simple form this morning . . . .

Thank you for all of your help.  

Lynn
0
 

Author Closing Comment

by:lthames
ID: 37709995
Very helpful information and very fast responses.
0
 
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 37710076
I don't think XFA forms are supported on the iPad.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question