I just inherited a project that is written in VB6. The application was using Sybase for it's data store. We're converting it to use MS SQL Server 2008 so a .NET web application can interact with the data as well. the whole application uses DAO for it's data interactions. Simple ad-hoc queries work fine but when calling stored procedures that do things such as delete or update I get invalid cursor location errors when trying to use any data that is returned from the SP.
Does any one know of the limitations with DAO and MS SQL stored procedures that might cause this and potentially have a fix?