Please pardon me if this is the wrong place to post this question. I am new to creating data connections to backend servers and really need some help here. I have a sql server table which I have full rights too. I have created a system dsn called DataConnection back to the database. That works fine. I created a form in Livecycle Designer ES2 and successfully made a data connection in LiveCycle called 'DataConnection' back to the table called 'Facts'. I'm able to generate the table fields on the form with no issue and I can see the first record populated when i do pdf preview. Question 1 - Why is it if I dont have 'delayed open' checked on the connection properties I receive a message box 'connection for Source DataConnection failed because the environment is not trusted'? Question 2 - For this test form, all I want to do is navigate and view the records (ie go to next, go to previous). I followed the sample from this page: http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/ and created my navigation buttons for previous and next. However, when click the buttons I receive the error that the operation failed because there was no connection specified. screenshot is attached. Can I someone tell me what I am missing here? Ultimately what I want is a form that will be available from a web server that people can navigate data through. The data will be on a sql table. There is no need to update, add or delete records. They will just view directly from this form . Am I going in the right direction? Any help is greatly appreciated. Mike
Views
Replies
Total Likes
Is your dataconnection called DataConnection? You can see what it is called by looking at the DataView palette. The root node will be the DataConnection name.
Paul
Views
Replies
Total Likes
yes it is called 'DataConnection' I purposely made sure that I kept the system dsn name and the connection name in livecycle the same.
Views
Replies
Total Likes
Are you using Acrobat or Reader to view your form?
Did you change any of the settings in the driver? I have not seen this error before but the message seems to indicate that the connection to the DB has been dropped. You could try and do an xfa.sourceSet.DataConnection.open() before you do the record manipulation.
Paul
Views
Replies
Total Likes
xfa.sourceSet.DataConnection.open() I've tried it in the preview, reader and acrobat pro and get same error. I left all default seetings when creating the connection. I tried adding xfa.sourceSet.DataConnection.open() to the formscript event when the button is clicked. I get the error connection for Source DataConnection failed because the environment is not trusted.
Views
Replies
Total Likes
I think that is the root of your issue .....we have to figure out why the environment is not trusted error is appearing. I believe that is a Windows error and
that there is some level of security that is kicking in because of it. I looked at the security settings in IE and under the Misc area there is an allow data sources across domains option there. Is that set to disable?
Paul
Views
Replies
Total Likes
I checked my IE settings and that option is set to enable. Do you think it could be something with my connection string?
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=scteach\admmmh;Initial Catalog=CertDev;Data Source=GANDALF;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=HAIRSTONXP;Use Encryption for Data=False;Tag with column collation when possible=False
Views
Replies
Total Likes
I do not know .....do you have anither database that you can try with? Maybe Access or something like that. I am trying to eliminate the connection string as well as the SQL Server database.
Paul
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies