AnsweredAssumed Answered

SQL Request Troubleshooting - works in "Run Now" but not on form

Question asked by on Feb 11, 2016
Latest reply on Jun 14, 2017 by lgiambar

I am trying to do a very simple query in the SQL request control.  When I'm configuring the action and click the Run Now button it works fine, but when I preview or publish the form it doesn't populate anything in the drop-down.  I'm on SharePoint 2013, forms version 2.9.  Anyone have any ideas on how to troubleshoot this?  Does it use the Secure Store config during the run now process or does it use my login?  Thanks in advance for any help.