Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 WrapperRead()

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 ??
Go to Top of Page

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 beginning

Go with the flow & have fun! Else fight the flow
Go to Top of Page

KRW
Starting Member

3 Posts

Posted - 2005-06-30 : 14:23:41
Did you change the packet size ? Did the change work ?
Go to Top of Page

Botto
Starting Member

7 Posts

Posted - 2005-09-23 : 08:26:48
Hi!

I use SET NOCOUNT OIN im My Sproc and the problem Continues

Anyone knows other SOlution?

Enlarge the Free Space For my Database?
if yes, how i do this?

Thanks

Botto
Go to Top of Page

Botto
Starting Member

7 Posts

Posted - 2005-09-23 : 08:27:42
DElete this post please
Go to Top of Page

Botto
Starting Member

7 Posts

Posted - 2005-09-23 : 08:41:45
Delete this post please
Go to Top of Page

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
Go to Top of Page

Botto
Starting Member

7 Posts

Posted - 2005-09-23 : 08:48:05
i´m new on SQL server 2K

how i can change the packet size?

tks
Go to Top of Page

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
Go to Top of Page

Botto
Starting Member

7 Posts

Posted - 2005-09-23 : 08:55:40
sorry, the problem Occurs in the Query Analyzer, just Executing the task.

Tkz

Botto
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-23 : 09:03:19
tools->options->connections->Network package size = 4096

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Botto
Starting Member

7 Posts

Posted - 2005-09-23 : 09:45:50
Don´t work this too...
I go to Reinstall my SQL server.

tkz

botto
Go to Top of Page

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ƒ‹‚𒲂ׂĂ­‚¾‚³‚¢�B

Connection Broken

It�Ls Strange couse the oriental Language shows in the error.
anyone knows something about this?

Tkz and Sorry my english
Go to Top of Page

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 0
General network error. Check your network documentation.

Connection Broken

This 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.
Go to Top of Page
   

- Advertisement -