Read-only access cursor error WIN98

[hinchdog]

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 --

http://support.microsoft.com/support/kb/articles/Q197/3/92.asp

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

 

[fluteplr]

I assume you are using ADO. Do you have the same version running on both machines??

 

[hinchdog]

Yes ADO. I don't know about the version though. What's the easiest way to check which version is running on a machine? Appreciate your help!

-Frank

 

[fluteplr]

look in your program files\common files\system\ado directory right click on one of the dlls that start with msado and check the version number. The first 3 digits should tell you which version. Mine show as 2.60.6526.0 which would be 2.6 (the one that was released with windows 2000)

 

[hinchdog]

The vesion I have on the NT system is 2.10.4202.0 (so is that considered 2.10?). I'll don't have access to the WIN98 system, but assuming the version is different what do I do then? upgrade? how? again, thanks.

-Frank

 

[Cagliostro]

What kind of cursor did you create?
You can update only with a forward only cursor and without such statement as group by, order by. John Fill

 

[hinchdog]

I created a SCROLL cursor. It works fine on NT but doesn't work for 98. I don't get it. Then when I use OpenQuery like th article suggest I get an ADO error. It's messed.

 

[Cagliostro]

I work on Win2k server, MSSQL7, and it can't update with scroll cursors. Only with ForwardOnly. You can try and look. Maybe it depends on MSSQL version and OS. John Fill

 

[hinchdog]

It's actually SQL 7.0. You may be right-on about the OS. I'll have to try it with a foward only cursor when I get home tonight. Thanks for your suggestion, I'll let you know how it goes.

Peace, Frank