On the Linux server, cd to the 20084/try1/sql directory and
execute mysql:
mj@enterprise:~/issues/mysql/20084/try1/sql$ /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 5.0.21-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database Bug20084;
Query OK, 1 row affected (0.01 sec)

mysql> use Bug20084;
Database changed
mysql> grant execute on Bug20084.* to 'Bug20084User'@'localhost' identified by 'john', 'Bug20084User'@'%' identified by 'john';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select on mysql.* to 'Bug20084User'@'localhost', 'Bug20084User'@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> source tables.sql;
Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> source storedProcedures.sql;
Query OK, 0 rows affected (0.00 sec)

mysql> source data.sql;
Query OK, 11 rows affected (0.01 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> call mj_spListRatingsOfRecipe(8);
+--------+---------------------+-----------+----------+
| Rating | Date                | FirstName | LastName |
+--------+---------------------+-----------+----------+
|      5 | 0000-00-00 00:00:00 | Mark      | Johnson  |
|      3 | 0000-00-00 00:00:00 | Ken       | DeleteMe |
+--------+---------------------+-----------+----------+
2 rows in set (0.09 sec)

Query OK, 0 rows affected (0.10 sec)

mysql> quit
Bye


On the W2k machine, I executed the compile batch files, 
first in the 20084\try1\src\datatier directory,
then in the 20084\try1\src\TestListRatingsOfRecipe directory.

Note, I compiled the mysql.data.dll using a locally generated
key pair.  This is not the key pair included in Bug20084.snk.
I used the following command line:
csc /target:library /debug+ /optimize- /r:ICSharpCode.SharpZipLib.dll /out:MySql.Data.dll *.cs common\*.cs Types\*.cs

Then, I made a code group (called Bug20084Group) with a membership
condition based upon the strong name of the RecipeDB*.dll.  I gave this 
code group FullTrust (required due to lack of mysql.data.dll 
allowing partially trusted callers).  (Note all have the same public
key, so all the RecipeDB*.dll's and TestList*.exe programs are
members of the code group.)

The connection string is obtained from the Registry value:
\\HKEY_LOCAL_MACHINE\SOFTWARE\MRJ\Bug20084\ConnectionString
The content of the Connection String is:
host=enterprise.mrj;Database=Bug20084;User ID=Bug20084User;Password=john

Execute the TestListRatingsOfRecipes* programs.
For "first", put "8" in the text box and click the button.
For "second" and "third" the value in the box is ignored.

The "first", "second", and "third" correspond to the commented segments
of code in RecipeRead.cs, where I tried one piece of code after another.

Note that the "first" segment of code is now behaving slightly differently
from when I originally reported the bug.  It is returning a data table.
However, the table is empty, which is not the result of calling the stored
procedure, as seen above.

