Re: foxpro view
- From: "Cindy Winegarden" <CindyWinegarden@xxxxxxxxxxxxxxxx>
- Date: Thu, 26 Jan 2006 11:01:18 -0500
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
cindy_winegarden@xxxxxxx www.cindywinegarden.com
"stephanie" <stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0D516C9-106E-4BDF-8555-DE8F4207B59C@xxxxxxxxxxxxxxxx
>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.
.
- Prev by Date: Re: GetParameterInfo for JET
- Next by Date: Save ADP Connection to UDL -> Data Link file is inaccessible error
- Previous by thread: GetParameterInfo for JET
- Next by thread: Re: foxpro view
- Index(es):
Relevant Pages
|
Loading