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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>>
>> >I am trying to rename a column name and it gives me the following error. Can
>> >any body help please. Thanks
>> >
>> >'MR_STRANS_051005' table
>> >- Unable to rename column from 'ATTR4' to 'GST_AMT'.
>> >ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
>>
>>

.

Relevant Pages

  • Linked Server Problem
    ... I have a view to a table in a linked server (an Access mdb ... file) that works fine in Enterprise Manager and Query ... Analyzer, but when the view is executed in the Access adp ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: stored procedure update HUGE PROBLEM
    ... Don't ever create or alter procs in Enterprise Manager. ... Use Query ... Analyzer and specify SET QUOTED_IDENTIFIER and ANS_NULLS ON or OFF as ...
    (comp.databases.ms-sqlserver)
  • RE: Enterprise Manager Shortcuts for Remote Servers
    ... I don't think I have a restriction for Query ... Does this mean I'd have to switch to Query Analyzer or are you suggesting ... that back to using Enterprise Manager? ... doesn't allow you to store a default database for each SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Source control integration with MSSQL 2000.
    ... I tested sqlXpress about a year or so ago. ... query plans, which was something I couldn't do without. ... > using both Query Analyzer and Enterprise Manager. ... > - Their website says "Replaces most features of Microsoft® Query Analyser ...
    (microsoft.public.sqlserver.server)