I have a stored procedure that uses a scroll cursor to perform some database updates. It works fine on NT, but when I try to use it on my home machine (98) I get the error "update failed, cursor is read-only". at first i thought it was a permission problem, but then i found this article --
I followed the example in the article and re-wrote my sp with the OpenQuery method but then I got the error "Server does not have Data Access Enabled". I'm about to go out of my mind here. Could someone please help me. Thanks.
-Frank
I followed the example in the article and re-wrote my sp with the OpenQuery method but then I got the error "Server does not have Data Access Enabled". I'm about to go out of my mind here. Could someone please help me. Thanks.
-Frank