PRB: Catastrophic Error Occurs Referencing ADO Recordset.

博客指出MS SQL Server使用时存在小问题,事务提交会破坏该数据库连接上的记录集。介绍了具体场景,先执行SQL查询产生记录集,再在同一连接上执行transact的commit或rollback操作,最后查询记录集时ADO会报错,还给出了MSDN文章参考。

MS SQL Server 使用时的一个小问题,事务提交会破坏该数据库连接上的记录集。场景如下:

1. 执行一个SQL 查询,产生一个记录集。

2. 在同一个数据库连接上执行一个transact的commit或者rollback操作

3. 去查询第一步的记录集。ADO会报错:“Using ADO 2.6 and later, the error is Run-time error '-2147418113(8000ffff)': ITransaction::Commit or ITransaction::Abort was called, and the object is in a zombie state. ”

具体参看MSDN文章:http://support.microsoft.com/default.aspx?scid=kb;en-us;187942

MOD_RRM_FDD, MOD_RRM_FDD_BASELINE_TRACE_ERROR_UH, [MS->NW] RR__ENHANCED_MEASUREMENT_REPORT Peer Message global_peer_msg_id = PROTOCOL_SECTION__RR_short_PD (enum 502) raw data = Buffer 0000 - 000F 10 6e 81 ff 85 42 54 dc f1 a3 80 00 00 00 00 00 0010 - 001F 00 00 00 00 00 Message Content GSM SACCH - Enhanced Measurement Report 0... .... = Radio Resources Short Protocol Discriminator: 0x00 .001 00.. = Radio Resources Short PD Message Type: Enhanced Measurement Report (0x04) .... ..00 = Radio Resources Short L2 Header: 0x00 0... .... = BA-USED: 0 .1.. .... = 3G-BA-USED: 1 ..1. .... = BSIC Seen: One Cell or more with invalid BSIC and allowed NCC part of BSIC is seen ...0 .... = Scale: 0 dB .... 1... = Serving cell data: Present Serving cell data .... .1.. = DTX-USED: DTX was used .... ..10 1000 .... = RXLEV-FULL-SERVING-CELL: -71 <= x < -70 dBm (40) .... 000. = RXQUAL-FULL-SERVING-CELL: BER < 0.2%, Mean value 0.14% (0) .... ...1 1111 .... = Mean BEP GMSK: log10(BEP) < -3.60 (31) .... 111. = CV BEP: 0.00 < CV BEP < 0.25 (7) .... ...1 1000 .... = Nb Rcvd Blocks: 24 .... 0... = Repeated Invalid BSIC Information: Not Present .... .1.. = Bitmap Type Reporting: Present Bitmap Type Reporting .... ..0. = Reporting Quantity: RSCP .... ...1 = Reporting Quantity: Ec/No Neighbour Cell List index: 1 0100 00.. = Reporting Quantity: 16 .... ..1. = Reporting Quantity: Ec/No Neighbour Cell List index: 2 .... ...0 0101 0... = Reporting Quantity: 10 .... .1.. = Reporting Quantity: Ec/No Neighbour Cell List index: 3 .... ..00 1101 .... = Reporting Quantity: 13 .... 1... = Reporting Quantity: Ec/No Neighbour Cell List index: 4 .... .100 111. .... = Reporting Quantity: 39 ...1 .... = Reporting Quantity: Ec/No Neighbour Cell List index: 5 .... 0001 10.. .... = Reporting Quantity: 6 ..1. .... = Reporting Quantity: Ec/No Neighbour Cell List index: 6 ...0 0011 1... .... = Reporting Quantity: 7 .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP 0... .... = Reporting Quantity: RSCP .0.. .... = Reporting Quantity: RSCP ..0. .... = Reporting Quantity: RSCP ...0 .... = Reporting Quantity: RSCP .... 0... = Reporting Quantity: RSCP .... .0.. = Reporting Quantity: RSCP .... ..0. = Reporting Quantity: RSCP .... ...0 = Reporting Quantity: RSCP [Malformed Packet: GSM SACCH] [Expert Info (Error/Malformed): Malformed Packet (Exception occurred)] [Malformed Packet (Exception occurred)] [Severity level: Error] [Group: Malformed] Lua Error: D:\elt2\QUEUE5~2\System\Bin\elt.lua:133: Dissector_call: Malformed frame [Expert Info (Error/Undecoded): Lua Error: D:\elt2\QUEUE5~2\System\Bin\elt.lua:133: Dissector_call: Malformed frame] [Lua Error: D:\elt2\QUEUE5~2\System\Bin\elt.lua:133: Dissector_call: Malformed frame] [Severity level: Error] [Group: Undecoded] TRACE_NAME, RR_MS_TO_NW_PEER_MSG_FDD
09-13
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值