Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pass thru sql fails after executing successfully the first time

Status
Not open for further replies.
Lorraine

Lorraine

Programmer
Aug 9, 2000
7
0
0
US
I'm working with pass thru sql that runs successfully the first time. However, if I attempt to rerun the sql, I receive an ODBC fail with the following message:

[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with th name 'Cursor1' already exists
(#16915)[Microsoft][ODBC SQL Server Driver][SQL Server]A cursor with th name 'Cursor2' already exists
(#16915)

I checked the database for a possible locking issue but found none.
 
Sort by date Sort by votes
You should deallocate cursor as
deallocate YourCursorName John Fill
ivfmd@mail.md
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
148
dhookom
dhookom
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
139
Swi
Swi
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
183
TheresAlwaysAWay
TheresAlwaysAWay
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
158
strongm
strongm
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
149
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top