I'm very new to Livecycle ES2 so sorry ahead of time for asking a possibly easy question. I have a form that I would like to have users type directly into, and have that data inserted, updated, deleted etc in a SQL DB(SQL Server 2008). I would also like to have dropdowns and a few other text fields ...

I'm using SQL user/pwd. But here' something else I just noticed. I have a drop-down list hooked up to an SQL table. In order for all of the records to show up in the drop-down, I need to do a File/Save As in Livecycle, and save the form as an Adobe Static PDF Form. If I don't, only the first record ...

UPDATE:I apologize, I was wrong, it does not work in Designer or Acrobat, but it DOES work in Reader. Any auggestions as to what's going on there??

Hey Kevin,Thanks for sticking with me, this issue occurs in both Designer and in Reader. I have tried everything and haven't found any answers online. I've looked back through Stefans forumsas well and cannot find out anything.

I'm new to Livecycle ES2 and I have searched high and low to find a reason as to why this error keeps occuring?? After I close the error message box, my drop-downs fill with ONLY the first record in my DB. I'm currently using SQL Server Native Client 10.0 Provider to connect to SQL Server 2008(This ...

I'll look into that and see what I can do. Thanks again for your help with theses issues.

Thanks very much for your timely response,I have used the Sql Native Driver option and heres what keeps happening. I continually get this error..."Connection for Source DataConnection failed because the environment is not trusted". It will then populate my form dropdowns with the first record form t...

Hello,I posted this about a week ago and have gotten some suggestions but still have not gotten a clear anwser. Regarding forms, can I hook my form to SQL Server 2008 WITHOUT using ODBC and a DSN? If so, how can this be done? I have a form that I would like to autopopulate some fields(dropdowns) fro...

Ok thanks, I'll check into those options.

Thanks so much for the suggestion as I may go that route. However I'm still curious to find out if using ODBC and setting up a DSN is an absoulute must? Of course I've hooked the form up via a DSN and it worked just fine. Any thoughts on the ODBC/DSN situation?