Error Message: Server: Msg 7392, Level 16, State 2 
Author Message
 Error Message: Server: Msg 7392, Level 16, State 2

Hi,

I have created a linked server between SQL Server 7.0 and
Access. I am trying to update and delete records in Access
database using cursors in a stored procedure. I am getting
Error Message: Server: Msg 7392, Level 16, State 2
The fix for this was suggested on the Microsoft support to
add: "Set XACT_ABORT ON" in the code. After adding that in
code, I am still getting the error message.
Please help me in getting this fixed.

The CODE is follows:
set XACT_ABORT ON

set transaction isolation level repeatable read
begin tran

DECLARE del_data cursor
keyset
for
select upper([id]) from test...[data table]

open del_data


BEGIN




begin

end


END

close del_data
deallocate del_data
commit tran
set transaction isolation level read committed



Sun, 24 Apr 2005 05:18:05 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Error: Server: MSG 7392, Level 16, State 2

2. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

3. Server: Msg 7399, Level 16, State 1, Line 1 error on .mdb as linked server

4. Select error:Server: Msg 8120, Level 16, State 1, Line 1

5. HELP - SQL Server 7.0 Error - Msg 542, Level 16, State 1

6. Server: Msg 107, Level 16, State 3 Error

7. Message Msg 6401, Level 16, State 1

8. Linked Server Error Message for Update (7343, Level 16, State 4)

9. Help.Error: Msg 7399, Level 16, State 1, Line 1

10. Msg 5159, Level 16, State 1 OS Error 38

11. Getting Error Msg 7343, Level 16, State 4

12. Help: SQL Error: Msg 7134, Level 16, State 2


 
Powered by phpBB® Forum Software