Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

Accessing SQL Table Views with LiveCycle Data Connection

Avatar

Level 1

I am creating a fillable PDF with a data connection to a SQL database. The idea is that when the user enters a unique value in one of the fields and presses a refresh button, the form will pull in certain fields of data from a SQL database. My issue is that, when creating the ODBC data connections in LiveCycle Designer, I only seem to have access to the tables in the database, not to the table views that have been created. In other tools such as Crystal Reports (that use the same DNS), I have access to both the tables and the views.

Does anyone know if it's possible to access the views as well as the tables in LiveCycle?

Thanks!

1 Reply

Avatar

Level 1

I have done this using a SQL Query instead of choosing a table.  You could try...'SELECT * FROM MY_VIEW WHERE THIS = THAT'

2016-03-15 16_43_16-OLEDB Connection.png