I have created a Dataprovider/SQLDataProvider/controller following Chris Hammond's tutorial videos.  I try to bind a stored procedure to a repeater as explained in the tutorial. (The datasource is pointing to a second database on my local machine.) 

When I bind the data to the repeater, it returns the 42 records that I expect, but the only value that will return is '0' for the key field.  It actually breaks when adding other fields.  If I run "exec stored procedure"  from the Host/SQL module using the other connection (in the drop down), I get the results expected.

Are there any permissions I need to give the database that I may have missed?  Has anyone else seen this behavior?  I'll happily post some code if that is needed. 

Thanks,

Gregg