@stephanie: "I have a view which select a foxpro table which connect with linked server.  
Once I show the view content, it shows an error
'OLE DB provider 'MSDASQL' for linked server 'ORS' returned data that does 
not match expected data length for column '[MSDASQL].cprodname'. The 
(maximum) expected data length is 30, while the returned data length is 60.'
Any idea on it?  Thanks in advance."
    @CindyWinegarden: "Hi Stephanie,
First, you may be better off using the FoxPro and Visual FoxPro OLE DB data 
provider, downloadable from msdn.microsoft.com/vfoxpro/downloads/updates.
Second, there's no way to really know what's wrong until you post the SQL 
code for your view and details about the table structure of the Fox table, 
at least for the field in question. Your error sounds like the field in the 
Fox table is 60 characters (Fox tables are always fixed width) and the field 
in your view is trying to be 30 characters.
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
<email_address>  <url>
"stephanie" <email_address> wrote in message 
news:<email_address>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.data.oledb.20140312.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}