MS SQL Server ODBC - ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor stat

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

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

Shan

2006-01-11, 11:23 am

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

Sue Hoegemeier

2006-01-17, 11:23 am

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:

>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

Sponsored Links