Skip navigation
Currently Being Moderated

Connecting to SQL Server using Native Client

Jul 2, 2006 7:07 PM

I am trying to create a form and am starting off with adding a dropdown box populated from a SQL Server table. I created the connection using the SQL Native Client and Windows Integrated Security. That worked fine and when I go to the properties of the drop down and configure the binding it shows me the fields. So far so good

When I go to PDF Preview I get a message saying "Connection for Source DataConnection failed because the environment is not trusted."

Have looked through the forums and there are a few messages but all seem to appertain to setting up a DSN. We have a few hundred users and I don't want to have to setup DSN's I want to use native SQL and windows authentication.

Is this possible?

Best Regards

Richard
 
Replies
  • Currently Being Moderated
    Jul 3, 2006 11:15 AM   in reply to (Richard_J_Ames)
    Typically, in order for the PDF to connect to a database source there needs be a DSN set up on the client. I believe if you certify your PDF, and the cert chains to a root that is trusted by the client machine, you can do what you're trying.

    In situations like yours I usually prefer to have 3 tiered architecture, where the PDF sends a request to a web service, which queries the database, and responds to the PDF instead of having the PDF connect directly to the database.

    Chris
    Adobe Enterprise Developer Support
     
    |
    Mark as:
  • Currently Being Moderated
    Jul 3, 2006 5:20 PM   in reply to (Richard_J_Ames)
    Sorry, I wasn't clear, what I meant by "typicallyl needs a DSN" is if you don't have a local DSN it won't work unless you do extra work.

    To certify an XFA form, add a signature field in Designer, save it as a PDF, open the PDF in Acrobat, click the sig field, choose the option to certify and follow the prompts.

    Chris
    Adobe Enterprise Developer Support
     
    |
    Mark as:
  • Currently Being Moderated
    Jul 4, 2006 4:48 AM   in reply to (Richard_J_Ames)
    An XFA form is any form created by Designer, whether dynamic or static.

    Certifying the PDF needs to be the last thing you do. If you certify the PDF, then open it in Designer it is converted back to an XDP, then when you save it out as a PDF again, it's a new PDF and will no longer be certified.

    The credential used to certify the PDF needs to chain to a root that is set as a trusted identity in Acrobat. Not sure if you can use a self signed cert for this, but you may be able to add your self signed cert as a trusted identity in Acrobat and have it work.

    Chris
    Adobe Enterprise Developer Support
     
    |
    Mark as:
  • Currently Being Moderated
    May 19, 2008 5:49 AM   in reply to (Richard_J_Ames)
    Any answers on this yet? I've been struggling for days now with a similiar scenario with a SQL ODBC connection and dropdowns. All I get is that frustraiting error beep when I click the dropdown.
     
    |
    Mark as:
  • Currently Being Moderated
    Jul 25, 2009 4:59 PM   in reply to (Chris_Trubiani)

    Could you please elaborate on the 'extra work' method or point me in a direction?  I'm trying to use form to auto-populate some dropdowns from the database for users who are not able to have a DSN setup on their local machine and who are not on the same network.

     

    There seems to be a sticking point with the secure environment requirement...

     

    Many thanks for your expertise, it is GREATLY appreciated and welcomed!

     

    -richard

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 26, 2010 10:54 AM   in reply to (Richard_J_Ames)

    Hi all,

    I justed posted a similiar question.  Did anyone ever get a drop down box to populate?  I can get text boxes to populate using DSN but not the drop down box.  If there is a different behavior for drop down's as opposed to text boxes?  I would like to buy the Livecycle but if I haven't solved this by the time the trial runs out I'm not going to buy it.

     

    Any ideas, anyone?

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)