Testing Enterprise Server to Call Sprocs
This is a sample app that test if Enterprise server can handle calling sprocs that return strings. I.e. a sproc that has a OUTPUT parameters that is a varchar.

Behavior:
When calling a sproc that has an OUTPUT parameter that is a varchar, an error is thrown saying that the Size is invalid and zero.  When the parameter is created in code, a size is set, so this appears to be a bug.

Expected behavior:
This sample app has a single form and a single BO. The form simply provides a combobox with all the customers that have orders.  When a customer is selected, a stored procedure is called (via a method of the BO) to retrieve a string that provides some details about the selected customers orders.

Setup:
Before running this solution you will need to add a stored procedure to the StrataFrameSample database. The script to add this sproc is in the sql folder of the solution.

You will also need to setup an ES server to connect to this StrataFrameSample database.  You will need to add the host name and remote data source (and port if it isn't 80) into the SetDataSources event handler in AppMain.vb.

The Test:
In AppMain.vb, in SetDataSources, there are two ways to connect to the data. The first is to connect directly using ConnectionManager. Run the solution and the expected behavior is seen.

The second method of data connection is to use ES.  Enter the host name and remote data source from the previously configured ES server into code. Comment out the ConnectionManager code and uncomment the ES code. Run it again. An error is reported that indicates that the Size of the third parameter is not set (value of 0).  However, in code (CusomtersBO.GetOrderSummary) that the size is set.
