Home > Archive > MS SQL Server ODBC > January 2006 > Re: ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor
Shan

2006-01-17, 11:23 am

Do you suggest putting SP4? Will it possibly solve the problem. Yes I am
using Enterprise manager and when changing colum name I get this error.
Thanks

"Sue Hoegemeier" wrote:

> Is this in an app or are you using a SQL Server tool to
> rename the column? If it's in Enterprise Manager, there was
> a bug with a build after SP3 that caused this - try using
> Query Analyzer instead.
>
> -Sue
>
> On Wed, 11 Jan 2006 08:45:02 -0800, "Shan"
> <Shan@discussions.microsoft.com> wrote:
>
>
>

Sue Hoegemeier

2006-01-17, 8:23 pm

My first suggestion is that you really should be using Query
Analyzer for those types of activities.
The issue you seem to have hit was corrected in SP4. See the
following:
FIX: An invalid cursor state occurs after you apply Hotfix
8.00.0859 or later in SQL Server 2000
http://support.microsoft.com/?id=831997

-Sue

On Tue, 17 Jan 2006 09:06:04 -0800, "Shan"
<Shan@discussions.microsoft.com> wrote:
[color=darkred]
>Do you suggest putting SP4? Will it possibly solve the problem. Yes I am
>using Enterprise manager and when changing colum name I get this error.
>Thanks
>
>"Sue Hoegemeier" wrote:
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com