I'm using the driver that comes with VFP 8 (version 8.0.0.3117). The "factor" field is Numeric (11,5).
>Dan,
>
>Are you using the latest version of the VFP OLE DB provider? What's the type/size of the Column 'factor' ?
>
>>I've created a linked server in SQL Server 2005 that points to a VFP DBC. When I run a query against a table, I get the following error:
>>
>>
>>OLE DB error trace [Non-interface error: Column 'factor' (compile-time
>>ordinal 5) of object 'BATCHITEM' was reported to have a PRECISION of 11 at
>>compile time and 10 at run time].
>>
>>Msg 7356, Level 16, State 1, Line 1
>>OLE DB provider 'VFPOLEDB.1' supplied inconsistent metadata for a column.
>>Metadata information was changed at execution time.
>>
>>
>>Anybody know what this means and how to fix this?