0 Replies Latest reply on Oct 23, 2014 5:18 AM by maths

    How to store and retrieve a PDF form to SQL Server from LiveCycle?

    maths Level 1

      My intention is to save a complete PDF form into a database and then later on retrieve this form from DB.
      To do this, SQL Server has got two datatypes, image or Varbinary(max). I am able to store a PDF using "Execute SQL Statement"(I have written an Insert statement). Some value is being written into DB as well.
      But when I try to retrieve this record using "Query Single Row"(I store the result to a doc variable), the retrieved PDF is of an unknown type and cannot be opened by Adobe Reader.

      I am not sure if my approach is correct. Is it possible to store/retrieve a PDF form to/from a DB through LiveCycle?
      If yes, please give me some guidance.