Expand my Community achievements bar.

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

Avatar

Former Community Member

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.

0 Replies