Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

DataConnection issues

Avatar

09-07-2008

Hello everyone,



I've recently delved into Adobe LC Designer ES in order to utilize the DataConnection feature. I have successfully created my DataConnection along with buttons that will cycle through the records housed in the sheet I'm referencing without much of an issue, however I need other PCs to be able to access the same data as well.



The FormCalc code I'm using for the buttons "on Click" is:



xfa.sourceSet.DataConnection.previous()

xfa.sourceSet.DataConnection.next()

etc...



These buttons work just fine as long as I'm accessing the form from the computer with the SQLExpress server and Designer, however once I send the PDF or access it over the network users can no longer use the buttons.



Am I overstepping the functionality of LC Designer or am I missing something even more basic like a SQL app on the client PC to connect to the SQL database that I'm referencing, or does that computer need Designer as well? I know almost nothing about SQL, so it's a miracle that I've even gotten this far. 😞



Thanks for any help that you can give!

Replies

Avatar

11-07-2008

have you checked your SQL server accessible from network PCs without any error?



I've used DataConnection based on SQL which works fine on network.

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

11-07-2008

Also you will need to create a DSN on each of the machines that will access the database.

Avatar

11-07-2008

Thanks for the help guys. I went ahead and created the DSN on another PC (and learned that it has to be named exactly the same!), however I found that my main issue was that the PC's only had Adobe Reader and not Pro. So after downloading the trial I was able to get it working without a problem.



Thanks again!

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

14-07-2008

You can Reader Extend the form to allow Reader to do data connections for you. If you are interested you will want to look at LiveCycle Reader Extensions.