Strange Insert problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Yaheya Quazi (yquazi_at_ucmerced.edu)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 13:45:10 -0700

I am trying to insert record in a local table grabbing
data from a linked server. I have teh same datatype in
both the database (datetime) but when I try to run the
insert statement I get the following error..

Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' returned an unexpected data
length for the fixed-length column '[mylinked].[qdb].
[dbo].[employee].rcnt_sepd_vet_date'. The expected data
length is 10, while the returned data length is 19.
OLE DB error trace [Non-interface error: Unexpected data
length returned for the column: ProviderName='SQLOLEDB',
TableName='[mylinked].[qdb].[dbo].[employee]',
ColumnName='rcnt_sepd_vet_date', ExpectedLength='10',
ReturnedLength='19'].

Relevant Pages

  • Funky Error
    ... length for the fixed-length column '. ... OLE DB error trace [Non-interface error: Unexpected data ...
    (microsoft.public.sqlserver.programming)
  • Re: Strange Insert problem
    ... instead of just the error message? ... "Yaheya Quazi" wrote in message ... > OLE DB error trace [Non-interface error: Unexpected data ...
    (microsoft.public.sqlserver.programming)