Invalid Cursor State Error

I know other people have posted stuff like this before, but I am still
to see a definitive answer. I have created a table in Enterprise
manager called tblUsers. I later added a column in EM and saved the
change. I then noticed I had misnamed the column, so I renamed and
when I tried to save the change I got the following message:-

'tblUsers' table
- Unable to rename column from 'fldepCode' to 'fldRepCode'.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state

This is now regularly happening to me, and I am tired of having to
recreate tables.

I am using SQL Server 2000 with all the latest service packs and
patches. Has anyone any idea what is causing this and how I can cure
it or avoid it?"Sam Evans" <sam.evans@.fuchs-oil.com> wrote in message
news:3fb4df1d.0401070435.5eba4784@.posting.google.c om...
> I know other people have posted stuff like this before, but I am still
> to see a definitive answer. I have created a table in Enterprise
> manager called tblUsers. I later added a column in EM and saved the
> change. I then noticed I had misnamed the column, so I renamed and
> when I tried to save the change I got the following message:-
> 'tblUsers' table
> - Unable to rename column from 'fldepCode' to 'fldRepCode'.
> ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
>
> This is now regularly happening to me, and I am tired of having to
> recreate tables.
> I am using SQL Server 2000 with all the latest service packs and
> patches. Has anyone any idea what is causing this and how I can cure
> it or avoid it?

Enterprise Manager's visual design features have a bit of a history of
similar issues; the best solution is probably to use Query Analyzer:

exec sp_rename 'SomeTable.fldepCode', 'fldRepCode', 'column'

Personally, I would prefer to use QA for this sort of task, as it allows for
more control and precision.

Simon|||Many thanks for the quick reply. I know I should use the best method,
not the simplest, but i resent having to remember any syntax, however
simple, when I already have a tool that's supposed to do the job! The
best answer would be for me to write a little vb.net app that will let
me choose a stored procedure, prompt me for parameters and run the SP.
Guess what, I already have one! A quick hack beckons!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

invalid attribute/option identifier

Hi
I currently have a problem with registering a new server in my Enterprise
Manager on a new PC.

I need to connect to a MSSQL2K server on a windows 2003.
My current PC is on the same LAN as the server and has no problem
registering the server in Enterprise manager. This PC uses NT (about time I
change :-)

The new PC runs WIN2K. But this PC is on another LAN and has to access the
server through a firewall. Port 1433 is open in the firewall.
I use a Firewall-1 authentication agent to access the server.

I use SQL authentification to logon (sa account), I have checked that the
new clients network libraries are the same version as the servers.
In the client network Utility I have set up an alias with the server I want
to access.

The registration seems to access the SQL server, but comes out with an error
stating: "invalid attribute/option identifier"

When I search KB with this message, I get nothing. Did anyone in here
experience anything like this? Any pointers to help me move on would be
greatly appreciated.

best regards
Ren Pedersen"Ren Pedersen" <rpe@.post6.tele.dk> wrote in message
news:4107a915$0$175$edfadb0f@.dtext01.news.tele.dk. ..
> Hi
> I currently have a problem with registering a new server in my Enterprise
> Manager on a new PC.
> I need to connect to a MSSQL2K server on a windows 2003.
> My current PC is on the same LAN as the server and has no problem
> registering the server in Enterprise manager. This PC uses NT (about time
I
> change :-)
> The new PC runs WIN2K. But this PC is on another LAN and has to access the
> server through a firewall. Port 1433 is open in the firewall.
> I use a Firewall-1 authentication agent to access the server.
> I use SQL authentification to logon (sa account), I have checked that the
> new clients network libraries are the same version as the servers.
> In the client network Utility I have set up an alias with the server I
want
> to access.
> The registration seems to access the SQL server, but comes out with an
error
> stating: "invalid attribute/option identifier"
> When I search KB with this message, I get nothing. Did anyone in here
> experience anything like this? Any pointers to help me move on would be
> greatly appreciated.
> best regards
> Ren Pedersen

There are a few hits on Google which suggest reinstalling MDAC and/or the
client tools, plus this post about a specific DLL:

http://groups.google.com/groups?hl=...ng.google .com

Simon|||Worked like a charm - thank you very much.

regards
Ren

"Simon Hayes" <sql@.hayes.ch> skrev i en meddelelse
news:4107ea67$1_2@.news.bluewin.ch...
> "Ren Pedersen" <rpe@.post6.tele.dk> wrote in message
> news:4107a915$0$175$edfadb0f@.dtext01.news.tele.dk. ..
> > Hi
> > I currently have a problem with registering a new server in my
Enterprise
> > Manager on a new PC.
> > I need to connect to a MSSQL2K server on a windows 2003.
> > My current PC is on the same LAN as the server and has no problem
> > registering the server in Enterprise manager. This PC uses NT (about
time
> I
> > change :-)
> > The new PC runs WIN2K. But this PC is on another LAN and has to access
the
> > server through a firewall. Port 1433 is open in the firewall.
> > I use a Firewall-1 authentication agent to access the server.
> > I use SQL authentification to logon (sa account), I have checked that
the
> > new clients network libraries are the same version as the servers.
> > In the client network Utility I have set up an alias with the server I
> want
> > to access.
> > The registration seems to access the SQL server, but comes out with an
> error
> > stating: "invalid attribute/option identifier"
> > When I search KB with this message, I get nothing. Did anyone in here
> > experience anything like this? Any pointers to help me move on would be
> > greatly appreciated.
> > best regards
> > Ren Pedersen
> There are a few hits on Google which suggest reinstalling MDAC and/or the
> client tools, plus this post about a specific DLL:
>
http://groups.google.com/groups?hl=...ng.google .com
> Simon