鏈接服務器返回字符超過本地字符長度

Msg 7347, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' for linked server 'CIM_MFG' returned data that does not match expected data length for column '[MSDASQL].ad_line1'. The (maximum) expected data length is 30, while the returned data length is 32.

解決方法：

轉換字符類型：

select * from openquery(CIM_MFG,'select ad_name,cast(ad_line1 as varchar(50)) as ad_line1,cast(ad_line3 as varchar(50)) as ad_line3,ad_addr,ad_attn,ad_phone,ad_fax from pub.ad_mstr')t