| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-12-10 : 07:48:01
|
| fabio writes "Hi,what i can do when, by code VB6 with "update tabxx....", return a message "-2147467259 : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead())."Thank and sorry my english." |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-12-10 : 09:59:01
|
| Where is Jeff with his crystal ball ?? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-10 : 10:10:51
|
i'll try it usually this happens if your packet size is too small. add packet size=4096; or larger some larger power of 2 into your connection string.if you're running an sproc use SET NOCOUNT ON at the beginningGo with the flow & have fun! Else fight the flow |
 |
|
|
KRW
Starting Member
3 Posts |
Posted - 2005-06-30 : 14:23:41
|
| Did you change the packet size ? Did the change work ? |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 08:26:48
|
| Hi!I use SET NOCOUNT OIN im My Sproc and the problem ContinuesAnyone knows other SOlution?Enlarge the Free Space For my Database?if yes, how i do this?ThanksBotto |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 08:27:42
|
| DElete this post please |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 08:41:45
|
| Delete this post please |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-23 : 08:44:20
|
have you increased the packet size?Go with the flow & have fun! Else fight the flow |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 08:48:05
|
| i´m new on SQL server 2Khow i can change the packet size?tks |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-23 : 08:51:06
|
i told you that in my first reply. just add that to your connection string.i've seen that fiy the problem.Go with the flow & have fun! Else fight the flow |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 08:55:40
|
| sorry, the problem Occurs in the Query Analyzer, just Executing the task. TkzBotto |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-23 : 09:03:19
|
tools->options->connections->Network package size = 4096Go with the flow & have fun! Else fight the flow |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 09:45:50
|
| Don´t work this too...I go to Reinstall my SQL server.tkzbotto |
 |
|
|
Botto
Starting Member
7 Posts |
Posted - 2005-09-23 : 10:33:38
|
| hi again. my error shows:[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).Server: Msg 11, Level 16, State 1, Line 0ˆê”Ê“I‚ȃlƒbƒgƒ��[ƒN ƒGƒ‰�[‚Å‚·�Bƒlƒbƒgƒ��[ƒN‚̃}ƒjƒ…ƒAƒ‹‚𒲂ׂĂ‚¾‚³‚¢�BConnection BrokenIt�Ls Strange couse the oriental Language shows in the error.anyone knows something about this?Tkz and Sorry my english |
 |
|
|
jbeckloff
Starting Member
1 Post |
Posted - 2006-03-20 : 17:03:17
|
| I get the same error too:[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()).Server: Msg 11, Level 16, State 1, Line 0General network error. Check your network documentation.Connection BrokenThis just started after I installed MDAC 2.8.I ran the same sp on the server and it works fine. I think the issue is with MDAC 2.8. |
 |
|
|
|