各位高手帮帮忙了看看这个
delphi+SQL Server编的程序，导入数据时报‘ General SQL error写入 SQL Server 失败。 常规网络错误’
一下为sql monitor 跟踪的结果
------------------------------------------------------------------------------------------
为后面部分内容
139 15:34:21 SQL Prepare: MSSQL - SELECT id ,rq ,pzlb ,pzbh ,dcdwdm ,dcdwmc ,dcckdm ,dcckmc ,drdwdm ,drdwmc ,drckdm ,drckmc ,jydm ,jymc ,dcsjdw ,dcsjsl ,dcsjdj ,dcdw ,dcsl ,dcdj ,dcje ,drsjdw ,drsjsl ,drsjdj ,drdw ,drsl ,drdj ,drje ,sbbz ,kpr FROM db ORDER BY id ASC
140 15:34:21 SQL Misc: MSSQL - Set statement type
141 15:34:21 SQL Execute: MSSQL - SELECT id ,rq ,pzlb ,pzbh ,dcdwdm ,dcdwmc ,dcckdm ,dcckmc ,drdwdm ,drdwmc ,drckdm ,drckmc ,jydm ,jymc ,dcsjdw ,dcsjsl ,dcsjdj ,dcdw ,dcsl ,dcdj ,dcje ,drsjdw ,drsjsl ,drsjdj ,drdw ,drsl ,drdj ,drje ,sbbz ,kpr FROM db ORDER BY id ASC
142 15:34:21 SQL Stmt: MSSQL - Fetch
143 15:34:21 SQL Stmt: MSSQL - EOF
144 15:34:21 SQL Stmt: MSSQL - Close
145 15:34:21 SQL Prepare: MSSQL - INSERT INTO db (id ,rq ,pzlb ,pzbh ,dcdwdm ,dcdwmc ,dcckdm ,dcckmc ,drdwdm ,drdwmc ,jydm ,jymc ,dcsjdw ,dcsjsl ,dcsjdj ,dcdw ,dcsl ,dcdj ,dcje ,sbbz ,kpr ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21)
146 15:34:21 SQL Data In: MSSQL - Param = 1, Name = id, Type = fldINT32, Precision = 0, Scale = 0, Data = 1
147 15:34:21 SQL Data In: MSSQL - Param = 2, Name = rq, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 12/1/2004 0:0:0:0
148 15:34:21 SQL Data In: MSSQL - Param = 3, Name = pzlb, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
149 15:34:21 SQL Data In: MSSQL - Param = 4, Name = pzbh, Type = fldBCD, Precision = 10, Scale = 0, Data = 1.0
150 15:34:21 SQL Data In: MSSQL - Param = 5, Name = dcdwdm, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 61100500
151 15:34:21 SQL Data In: MSSQL - Param = 6, Name = dcdwmc, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 定边县烟草公司
152 15:34:21 SQL Data In: MSSQL - Param = 7, Name = dcckdm, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 1
153 15:34:21 SQL Data In: MSSQL - Param = 8, Name = dcckmc, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 大库
154 15:34:21 SQL Data In: MSSQL - Param = 9, Name = drdwdm, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 61100501
155 15:34:21 SQL Data In: MSSQL - Param = 10, Name = drdwmc, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 城区批发部
156 15:34:21 SQL Data In: MSSQL - Param = 11, Name = jydm, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 31010101
157 15:34:21 SQL Data In: MSSQL - Param = 12, Name = jymc, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 中华(全硬)
158 15:34:21 SQL Data In: MSSQL - Param = 13, Name = dcsjdw, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 条
159 15:34:21 SQL Data In: MSSQL - Param = 14, Name = dcsjsl, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 50.00
160 15:34:21 SQL Data In: MSSQL - Param = 15, Name = dcsjdj, Type = fldBCD, Precision = 20, Scale = 10, Data = 360.0
161 15:34:21 SQL Data In: MSSQL - Param = 16, Name = dcdw, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 条
162 15:34:21 SQL Data In: MSSQL - Param = 17, Name = dcsl, Type = fldBCD, Precision = 12, Scale = 3, Data = 50.0
163 15:34:21 SQL Data In: MSSQL - Param = 18, Name = dcdj, Type = fldBCD, Precision = 20, Scale = 10, Data = 360.0
164 15:34:21 SQL Data In: MSSQL - Param = 19, Name = dcje, Type = fldBCD, Precision = 12, Scale = 2, Data = 18000.0
165 15:34:21 SQL Data In: MSSQL - Param = 20, Name = sbbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
166 15:34:21 SQL Data In: MSSQL - Param = 21, Name = kpr, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 雷静
167 15:34:21 SQL Transact: MSSQL - XACT Begin
168 15:34:21 SQL Execute: MSSQL - INSERT INTO db (id ,rq ,pzlb ,pzbh ,dcdwdm ,dcdwmc ,dcckdm ,dcckmc ,drdwdm ,drdwmc ,jydm ,jymc ,dcsjdw ,dcsjsl ,dcsjdj ,dcdw ,dcsl ,dcdj ,dcje ,sbbz ,kpr ) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21)
169 15:34:21 SQL Stmt: MSSQL - Close
170 15:34:21 SQL Prepare: MSSQL - SELECT id ,rq ,pzlb ,pzbh ,dcdwdm ,dcdwmc ,dcckdm ,dcckmc ,drdwdm ,drdwmc ,drckdm ,drckmc ,jydm ,jymc ,dcsjdw ,dcsjsl ,dcsjdj ,dcdw ,dcsl ,dcdj ,dcje ,drsjdw ,drsjsl ,drsjdj ,drdw ,drsl ,drdj ,drje ,sbbz ,kpr FROM db WHERE id=:1
171 15:34:21 SQL Data In: MSSQL - Param = 1, Name = id, Type = fldINT32, Precision = 0, Scale = 0, Data = 1
172 15:34:21 SQL Misc: MSSQL - Set statement type
173 15:34:21 SQL Execute: MSSQL - SELECT id ,rq ,pzlb ,pzbh ,dcdwdm ,dcdwmc ,dcckdm ,dcckmc ,drdwdm ,drdwmc ,drckdm ,drckmc ,jydm ,jymc ,dcsjdw ,dcsjsl ,dcsjdj ,dcdw ,dcsl ,dcdj ,dcje ,drsjdw ,drsjsl ,drsjdj ,drdw ,drsl ,drdj ,drje ,sbbz ,kpr FROM db WHERE id=:1
174 15:34:22 SQL Error: MSSQL - 警告: 严重错误 3624 发生于 12 3 2004 3:34PM
175 15:34:22 SQL Error: MSSQL - Warning: Fatal error 3624 occurred at 12 3 2004 3:34PM
176 15:34:22 SQL Error: MSSQL - 警告: 严重错误 3448 发生于 12 3 2004 3:34PM
177 15:34:22 SQL Error: MSSQL - Warning: Fatal error 3448 occurred at 12 3 2004 3:34PM
178 15:34:22 SQL Error: MSSQL - 警告: 严重错误 3314 发生于 12 3 2004 3:34PM
179 15:34:22 SQL Error: MSSQL - Warning: Fatal error 3314 occurred at 12 3 2004 3:34PM
180 15:34:22 SQL Error: MSSQL - 警告: 严重错误 9001 发生于 12 3 2004 3:34PM
181 15:34:22 SQL Error: MSSQL - Warning: Fatal error 9001 occurred at 12 3 2004 3:34PM
182 15:34:22 SQL Error: MSSQL - 警告: 严重错误 3314 发生于 12 3 2004 3:34PM
183 15:34:22 SQL Error: MSSQL - Warning: Fatal error 3314 occurred at 12 3 2004 3:34PM
184 15:34:22 SQL Error: MSSQL - 警告: 严重错误 9001 发生于 12 3 2004 3:34PM
185 15:34:22 SQL Error: MSSQL - Warning: Fatal error 9001 occurred at 12 3 2004 3:34PM
186 15:34:22 SQL Error: MSSQL - 警告: 严重错误 3314 发生于 12 3 2004 3:34PM
187 15:34:22 SQL Error: MSSQL - Warning: Fatal error 3314 occurred at 12 3 2004 3:34PM
188 15:34:22 SQL Error: MSSQL - 警告: 严重错误 9001 发生于 12 3 2004 3:34PM
189 15:34:22 SQL Error: MSSQL - Warning: Fatal error 9001 occurred at 12 3 2004 3:34PM
190 15:34:22 SQL Error: MSSQL - 警告: 严重错误 3314 发生于 12 3 2004 3:34PM
191 15:34:22 SQL Error: MSSQL - Warning: Fatal error 3314 occurred at 12 3 2004 3:34PM
192 15:34:22 SQL Error: MSSQL - Unmapped SQL Error Code: 21
193 15:34:22 SQL Stmt: MSSQL - Close
194 15:34:22 SQL Transact: MSSQL - XACT Abort
195 15:34:22 SQL Prepare: MSSQL - ROLLBACK TRAN
196 15:34:22 SQL Execute: MSSQL - ROLLBACK TRAN
197 15:34:22 SQL Error: MSSQL - 可能发生网络错误: 写入 SQL Server 失败。 常规网络错误。请查阅文档。
198 15:34:22 SQL Error: MSSQL - Unmapped SQL Error Code: 10025
199 15:34:22 SQL Stmt: MSSQL - Close
-------------------------------------------------------------------------------------
有没有人知道是什么地方的问题呀?
问题点数：0、回复次数：5Top
1 楼yelook（香槟酒）回复于 2004-12-03 17:04:56 得分 0
我不知道,帮你顶顶Top
2 楼Blue55（雨冬）回复于 2004-12-03 17:07:41 得分 0
帮我看看后面那几个错误是什么意思呀Top
3 楼Blue55（雨冬）回复于 2004-12-04 23:06:57 得分 0
又没有人帮帮忙亚 没有人见过吗?Top
4 楼Blue55（雨冬）回复于 2005-01-16 15:55:18 得分 0
我已经解决了是导入的时候一个表损坏了导致的Top
5 楼Softlee81307（孔腎）回复于 2005-01-16 16:17:36 得分 0
^_^Top
