"Scott McNair" <scott.mcnair@sfmco.takethispartout.com> wrote in message
news:Xns94F062394F10Esfmco@207.46.248.16...
> I just set up a linked server between two SQL Server 2000 boxes. I then
> tried a query against a view on the linked server, and I get this error:
>
> Server: Msg 7341, Level 16, State 2, Line 1
> Could not get the current row value of column '[linked_server].[database].
> [dbo].[view].[FieldName]' from the OLE DB provider 'SQLOLEDB'.
> [OLE/DB provider returned message: Requested conversion is not supported.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned
> 0x80040e1d].
>
> The field in question is a varchar(255) field. The view runs fine when I
> go to the server correctly, and other views run fine over the linked
server
> - it's only this view on this link.
>
> Any ideas why?

> I just set up a linked server between two SQL Server 2000 boxes. I then
> tried a query against a view on the linked server, and I get this error:
>
> Server: Msg 7341, Level 16, State 2, Line 1
> Could not get the current row value of column '[linked_server].[database].
> [dbo].[view].[FieldName]' from the OLE DB provider 'SQLOLEDB'.
> [OLE/DB provider returned message: Requested conversion is not supported.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned
> 0x80040e1d].
>
> The field in question is a varchar(255) field. The view runs fine when
> I go to the server correctly, and other views run fine over the linked
> server - it's only this view on this link.