Hi, 

I'm new to DNN and am using Dynamic Forms to create a form on a page. I have a SQL driven drop down box that should pull information from the SQL database provided by DNN. However, every time I enter a query, I keep getting an error that says "error in SQL. Please check your query under Host/SQL," but the query runs as it should in SQL. If anyone help me, I'd greatly appreciate it! 

Thanks

Also, if it helps, the textbox fields work just fine with the SQL DB. Any information from them gets properly passed to the tables I created for them. The data goes into the database but I'm having trouble retrieving it from the database for the drop down boxes. 

Sure, the purpose of this query is to pull the state abbreviations from a table I have created.

SELECT State_Code AS QuestionOption, State_Code AS QuestionOptionValue FROM State;

I didn't create them using {databaseOwner} and {objectQualifier}. The web.config file shows that there is no objectQualifier set. Also with the databaseOwner and objectQualifier included in query, the query won't even run in SQL. 

I keep getting the error message even if I include the databaseOwner from my web.config and a blank objectQualifier.