I was able to create a DataSource Query using property expansion and tested it to completion, but when I try to run it in the full test case it fails to run with a Network Adpater Error:

TestCase failed [java.lang.Exception: Failed to prepare testStep [DataSource]; java.sql.SQLException: Io exception: The Network Adapter could not establish the connection:java.lang.Exception: Failed to prepare testStep [DataSource]; java.sql.SQLException: Io exception: The Network Adapter could not establish the connection], time taken = 0

How can it retrieve rows when I test the step seperately, but not as part of the Test Case?

Here it is...I'm able to run the step stand alone though?

Ok - I ran it hard coded and it runs in the test case, but I still need a variable in the SQL query that is not being picked up!