cursor

[ewin740]

SQL server 2000 (SP4) is giving this error message on the user's desktop when accessing the user database via frontend client app:

"Error # [1526]: Connectivity Error: [Microsoft] [ODBC SQL server drive][SQL Server]A cursor with the name 'curapcapp' already exists. SQL Stmt" and then a bunch of other stuff appears.

i'm not sure what that cursor with the same name already exists means?

 

[ptheriault]

It means your app is trying to create a cursor that already exists.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[monksnake]

Deallocate that cursor, that will clear the error.


DEALLOCATE curapcapp

<.

 

[mrdenny]

First don't use cursors.

If you must use cursors be sure to close and deallocate them after you finish using them.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ewin740]

The error went away but replaced by a new one

error # [1526]: connectivity error: [Microsoft] ODBC SQL server Driver][SQL Server] Invalid object name '#tkeepapppmt'
SQL stmt: Insert into apvchk (cuid,cvendno,cpayto,cchktype, cbankno....)

 

[mrdenny]

Can you send the code for the entire batch?

Sounds like you are trying to use a temp table which you haven't created yet.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com