Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
?
674 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

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
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…

618 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