Hi I am using a SQL statement in Microsoft Query Analyzer
It is retrieving data from a dBase III File.
SELECT *
FROM OPENROWSET ('MSDASQL','Driver=Microsoft Visual FoxPro Driver;
SourceDB=\\max\C\D\BetterBeef\DBF\;
SourceType=DBF','select * from VSHPITMS')
If I limit the row to "WHERE SHIPMUM = '12345' then it will return rows, otherwise it gives this error
Server: Msg 7341, Level 16, State 2, Line 1
Could not get the current row value of column '[MSDASQL].itm_num' from the OLE DB provider 'MSDASQL'. Conversion failed because the data value overflowed the data type used by the provider.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
There are 2 columns that give this error
one thta has a datatype of Numeric(3,0) and one that has a datatype of Numeric(4,0)
The Numeric(3,0) field's max value is 999
Two other fields of type Numeric(7,0) and Numeric(10,3) do not produce the error.
Do you know of a workaround or what I am doing wrong. Thanks
It is retrieving data from a dBase III File.
SELECT *
FROM OPENROWSET ('MSDASQL','Driver=Microsoft Visual FoxPro Driver;
SourceDB=\\max\C\D\BetterBeef\DBF\;
SourceType=DBF','select * from VSHPITMS')
If I limit the row to "WHERE SHIPMUM = '12345' then it will return rows, otherwise it gives this error
Server: Msg 7341, Level 16, State 2, Line 1
Could not get the current row value of column '[MSDASQL].itm_num' from the OLE DB provider 'MSDASQL'. Conversion failed because the data value overflowed the data type used by the provider.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
There are 2 columns that give this error
one thta has a datatype of Numeric(3,0) and one that has a datatype of Numeric(4,0)
The Numeric(3,0) field's max value is 999
Two other fields of type Numeric(7,0) and Numeric(10,3) do not produce the error.
Do you know of a workaround or what I am doing wrong. Thanks