Showing posts with label severity. Show all posts
Showing posts with label severity. Show all posts

Friday, March 9, 2012

Invalid buffer received from client..

Invalid buffer received from client..
Error: 17805, Severity: 20, State: 3
Anybody else has this? Any rumors about a fix to it?I know SQL SP3 has added a bunch of new error messages for things we were all blissfully unaware of before. This looks like one of them. If this is taking your server down, you can look into the fix on KB article 818897.|||That's where I started, but realized that this patch eliminates the AV, not the fact that the proc will fail anyway and the error will sill post.

I found a similar issue raised in ms sqlserver news group, where they had a declaration discrepancy between a passed NVARCHAR param and param definition in the proc (VARCHAR). Once they mirrored the definitions the error disappeared. In our case there is nothing to change, on both sides the parm declared as TEXT (or so my developers say it is on FE). Of course, I'll make sure they're not "exagerating" :), but the fact stays for now, - TEXT = TEXT.

Invalid buffer received from client

Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
We just restored a SQL SRV 7 database to a SQL SRV 2000 on a new server.
The front end application is in VB 6. The above error message is being
logged in the server event viewer approximatly 30 times a day. Any
suggestions on any corrective action would be appreciated.Try to look if you have any types mismatch between front
end and SQL Server objects. For example type mistmach
between stored procedure parameter and front end variable
which you are trying to pass to this SP.
Regards.
----
All information provided above AS IS.
>--Original Message--
>Error: 17805, Severity: 20, State: 3
>Invalid buffer received from client.
>We just restored a SQL SRV 7 database to a SQL SRV 2000
on a new server.
>The front end application is in VB 6. The above error
message is being
>logged in the server event viewer approximatly 30 times a
day. Any
>suggestions on any corrective action would be appreciated.
>
>.
>|||Also it can happen if your clients MDAC is outdated.
Regards.
---
All information provided above AS IS.
>--Original Message--
>Error: 17805, Severity: 20, State: 3
>Invalid buffer received from client.
>We just restored a SQL SRV 7 database to a SQL SRV 2000
on a new server.
>The front end application is in VB 6. The above error
message is being
>logged in the server event viewer approximatly 30 times a
day. Any
>suggestions on any corrective action would be appreciated.
>
>.
>