Error 7347

We are getting Error 7347 error while querying via link server to Sybase. No
w this error is produced only in case of few tables. Query for other tables
is fine. There is another link server to the same sybase server but to a dif
ferent database and that it
fine.
Any help is appreciated
Here is the complete error message
****************************************
Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'Sybase.ASEOLEDBProvider' returned an unexpected data length
for the fixed-length column '[pds].[pds].[dbo].[product].cu
stodian_code'. The expected data length is 15, while the returned data lengt
h is 4.
OLE DB error trace [Non-interface error: Unexpected data length returne
d for the column: ProviderName='Sybase.ASEOLEDBProvider', TableName='[p
ds].[pds].[dbo].[product]', ColumnName='custodian_code', Expecte
dLength='15', ReturnedLength='4'].Hi,
////
The IDENTITY function should be used only when the SELECT statement has an
INTO clause.
Explanation:
Command failed due to invalid or illegal request. Check syntax, semantics,
and permissions. Take any corrective action indicated by message.
////
The sybase manual gives this explanation for the Error number 7347.I dont
know what query u are firing onto the server but just check if u are missing
something specified in the explanation
regards
Dilish
"Nishu" <anonymous@.discussions.microsoft.com> wrote in message
news:A98F91AB-9EFB-4F31-9281-2407BB0D2BE7@.microsoft.com...
> We are getting Error 7347 error while querying via link server to Sybase.
Now this error is produced only in case of few tables. Query for other
tables is fine. There is another link server to the same sybase server but
to a different database and that it fine.
> Any help is appreciated
>
> Here is the complete error message
> ****************************************
> Server: Msg 7347, Level 16, State 1, Line 1
> OLE DB provider 'Sybase.ASEOLEDBProvider' returned an unexpected data
length for the fixed-length column
'[pds].[pds].[dbo].[product].custodian_code'. The expected d
ata length is
15, while the returned data length is 4.
> OLE DB error trace [Non-interface error: Unexpected data length returned[/col
or]
for the column: ProviderName='Sybase.ASEOLEDBProvider',
TableName='[pds].[pds].[dbo].[product]', ColumnName='custodi
an_code',
ExpectedLength='15', ReturnedLength='4'].