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.