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

Database Connection

Avatar

13-10-2008

Im new to working with Livecycle. I am attempting to connect to a SQL database. Im able to setup the connection easy enough and select the table i want to query, but when I enter the field in to the binding section and test it. the field only displays the first value. Ive tied it different ways with different types of objects (list box, combo box, ect) .any ideas what Im missing...?

Replies

Avatar

Avatar
Level 1
_Anthony_Idigo_
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
_Anthony_Idigo_
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
_Anthony_Idigo_
Level 1

19-12-2008

Thanks for your prompt response.



The database is Oracle. In oracle i have already created the table space and loaded just one table with 3 columns, no rows of data. I have used the 3 column names to create the form fields. I now ant to place a submit button that when clicked on. Will send the data to and populate the columns in the table space in a dataware house.



So for example, I have a Table1 with 3 columns- column A, column B, column C that are empty. When the user receives the form it will have 3 fields binded to the 3 columns, and fill it out, it will now take the information and populate the 3 columns so now in the table will be 3 columns and 1 row. When a second, third and so forth fill out the form, it will know to append the table space and not do an insert or overwrite previous data.



Let me know if you need further information.



Thanks again

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 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

612 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

19-12-2008

Then what I recommen is to have the user submit the data from thre form to an intermediary program that will recieve the data and write it to the data base on behalf of the user. This program can be written in any kind of programming language but it must run on the web server.



You can write to the database directly from the form using OLEDB connections but it requires you to create a DSN on each machine. This becomes an administrative nighmare as user will not know how to do this as well as having any one who gets the form to connect to the DB.



The single program approach keeps the data base connectivity in a single place so that if anything were to change in that DB you would only have to update 1 single program.

Avatar

30-12-2008

Hello Paul:



Could you send me this code as well. I know it is an older post but I am having the same problem. I Get Connection for Source TIMS failed because the environment is not trusted.



Thank you Paul



Jeff

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 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

612 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

05-01-2009

I do not have source for that itermediary program. I was simply recommending an approach. The program that you create will be dependant on the web server used. I am sure that there are many examples in th eweb of the program that you will need.

Avatar

09-02-2009

Paul-



I'm trying to create a pdf form with which a user enters into a field a customer # and the form populates some other fields (like name, address etc.) with values retrieved from an SQL Query based on the cust #. (Something like Select * From customers Where custID = uh, 'the value entered by the user') I'm having (I think) a similar issue as Jason and others....I would like to query SQL in my data connection to bring back and display a specific record and not just the first record in the table. Am using CS3 Acrobat/LiveCycle Designer 8.0 and can't get it to work. Could you possibly send me the same code you sent him and others? Or possibly any other info that would point me in the right direction?



Thanks for your time



Rob

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 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

612 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

09-02-2009

I can send you the sample I used but I will need your email address to send it to.

Avatar

09-02-2009

Wow, I didnt expect such a fast response...thanks. My email is rob@chameleon59.com

best,

rob

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 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

612 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

10-02-2009

Just sent it

Avatar

Avatar
Validate 1
Level 10
Niall_O_Donovan
Level 10

Likes

646 likes

Total Posts

4,352 posts

Correct Reply

786 solutions
Top badges earned
Validate 1
Boost 500
Boost 50
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 10
Niall_O_Donovan
Level 10

Likes

646 likes

Total Posts

4,352 posts

Correct Reply

786 solutions
Top badges earned
Validate 1
Boost 500
Boost 50
Boost 5
Boost 3
View profile
Niall_O_Donovan
Level 10

10-02-2009

Hi Paul,



I would be grateful if you could also send it to me at niall.odonovan@assurehsc.ie Thanks!

Avatar

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
_nickarmstrong_
Level 1

11-03-2009

Hello everyone,



I am working on a Form with Livecycle in the exact same way. I've been using "Next" and "previous" buttons to cycle through the records, but it would be great to type in a record number and have it pop the other fields.



Also, if a sample doesn't help me figure it out, i would like to take those populated fields, and use them to reference another data connection. Some times your SQL data is in more than one table.



Paul, if you are still watching this forum, the sample you gave would be great for me to look at. narmstrong@smilebpi.com



Or if someone else has the sample, feel free to email it to me.



thank you all!