OLEDB error with SQL 2005

From: imradzi@xxxxxxxxx
Date: 19 Jun 2006 20:30:24 -0700

Hi,

I was running my OLEDB C++ program for quite sometime on sql server
2000/MSDE without any problem; but when I upgrade my sql server to
2005, I have this problem in some update routine.
This is the error message:

HRESULT:80040E14
SQLSTATE:42000
Native Error:8026
Source:Microsoft OLE DB Provider for SQL Server
Error message:
The incoming tabular data stream (TDS)
remote procedure call (RPC) protocol stream is incorrect.
Parameter 3 (""): The RPC is marked with the metadata unchanged flag,
but data type 0xAF has an actual length different from the one sent
last time.

It seems to affect STRING parameters.

TIA.

Radzi.

.

Follow-Ups:
- Re: OLEDB error with SQL 2005
  - From: Erland Sommarskog
- Re: OLEDB error with SQL 2005
  - From: Radzi

Prev by Date: Re: How to return counter value from Access
Next by Date: Re: OLEDB error with SQL 2005
Previous by thread: Re: Handling Concurrency in an Access DB using VB .Net 2003 and Jet Ol
Next by thread: Re: OLEDB error with SQL 2005
Index(es):
- Date
- Thread

Relevant Pages

RE: Qry Analyzer Debug broken: XP SP2
... The reason for Error 508 and Error code 0x80070005 is ... How to configure Windows XP Service Pack 2 for use with SQL Server ... The error code 0x800706ba translates to "RPC server ... unchecked on the client machine, this is a default setting that is checked. ...
(microsoft.public.sqlserver.server)
RE: Problem:fail to invoke remote RPC method
... > distributed transaction on the sql server machine, both machines have the sp2 ... > the rpc services are running, msdtc service are running, ... > Firewall Port Settings: ...
(microsoft.public.sqlserver.connect)
Problem:fail to invoke remote RPC method
... I have two xp sp2 machines(one desktop with sql server running, ... Firewall Port Settings: ... RPC server is ready ...
(microsoft.public.sqlserver.connect)
RE: Problem:fail to invoke remote RPC method
... "Stuart" wrote: ... >> distributed transaction on the sql server machine, both machines have the sp2 ... >> the rpc services are running, msdtc service are running, ...
(microsoft.public.sqlserver.connect)
Re: Single-instance within a network
... I think RPC uses UDP, but that does not matter much here. ... My program reads a SQL Server database, but it does so using ADO and I would ... Access database and the sharing modes and such for SQL Server and Access ...
(microsoft.public.vb.winapi)