How to return records from an MS SQL Database

[jsuber-tchd]

I have created a small form in Adobe LiveCycle 9.  I setup a new data connection to a database on my MS SQL server 2008.  I can see my sql data fields under the data connection tab and bound them to my corresponding fields in my form.  The form populates with information from the first record in my database.

I would like to create a field on my form where my users could enter in an account number and then my fields would populate from that record.  Right now I can only see the record with account number 1.

Any help would be appreciated.

[Former Community Member]

You will need to program the connection to get the specific record that you want. There is a sample that was created using MSAccess but the concepts are exactly the same. Here is a link to the blog entry:

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

Paul

[jsuber-tchd]

I am getting an error message that states the Connection for source DataConnection failed because the environment is not trusted.  How can I fix this?

Thank you for your help!

Jon

[Former Community Member · Accepted solution]

That is a Microsoft security error and I think it has to do with who (which rights) creates theDSN. You might want to do a web search to see how to overcome it ...or I have always used the admin account to add the DSN and not had the problem.

Paul

[jsuber-tchd]

This DNS is created inside of LiveCycle or on the client pc using the Data Source in the control panel?  My connection works when I preview the .pdf inside of LiveCycle.  Thanks for your help.

[jsuber-tchd]

I created a new user on my sql server that matched the login on my pc. (domain\user)  I then mapped the new user to the database.  Thanks for your help. Jon