Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Provider cannot determine value
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Provider cannot determine value
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Vista
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01257211
Message ID:
01257211
Views:
110
We are using VFPOLEDB from SQL Server 2000 to pull VFP data with "OPEN QUERY" but for some reason on a table called BID_SUBMIT for a field Material_Factor, which has an Input Mask of "999%" defined, as soon as we try to query any records with values over "99" we get the below error:
Server: Msg 7341, Level 16, State 2, Line 3
Could not get the current row value of column '[Rowset_1].material_factor' from the OLE DB provider 'VFPOLEDB'. The provider cannot determine the value for this column.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IRowset::GetData returned 0x80040e21:  Data status returned from the provider: [COLUMN_NAME=material_factor STATUS=DBSTATUS_E_UNAVAILABLE]].
Any thoughts?
Next
Reply
Map
View

Click here to load this message in the networking platform