Groups | Blog | Home
all groups > sql server odbc > october 2003 >

sql server odbc : Connection broken error


jose
10/22/2003 10:55:14 AM
hi,

I have a application that has many stored procedure running
fine on a Win 2000 sp3 / SQL 7 sp3 server.

Recently i created a new proc. and when i run it the=20
system always abort the execution and shows the message:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0


This proc. inserts records on a table and i noticed that=20
each time i run it the proc stops after inserting a=20
different number of rows. Sometimes just after 30 records=20
(when running on the Query analyser, and sometimes after=20
270 records when running on the MICROSOFT development=20
Environment 2002.

When i get the same stored procedure restore it on a=20
different server and run it the system completes the=20
execution with no problem.

Is there any way to identify why the same proc. that runs=20
on a server does not run in other server and aborts with=20
the message mentioned above?

Thanks a lot for your support

gary
10/22/2003 7:51:43 PM

[quoted text, click to view]
2000. If not you will need to update the mdac to 2.7 it=20
can be found in=20
http://www.microsoft.com/downloads/search.aspx?
josé
10/23/2003 6:47:32 AM
HI,

I had already installed MDAC 2.8 but i got the same errors.
I did not understood why you said that i shuoul have=20
sql2000 driver because my database is SQL 7.0. And if i=20
run the procedure in the query analyser that does not need=20
odbc support i get the same error.
I think that this problem has something to do with the=20
sqlserver buffer, because each time the error appears=20
after a different number of rows has been inserted in the=20
table. Sometimes i get the error after 270 lines,=20
sometimes after 280 and so.

thanks a lot for your response.



[quoted text, click to view]
AddThis Social Bookmark Button