Error Reading Certain Numeric Values With VFPOLEDB Driver

It appears that the VFPOLEDB driver tries to convert numeric types in VFP to decimal types in .NET. In this case, it's a Numeric 9,3 in VFP and it's trying to put it into a decimal 8,3 in .NET.

I know that VFP has this funny quirk where if you don't use all of the decimal places after the decimal point, it allows you to use extras in front of the decimal point. In our case, the number is 104895.83 and yes, VFP is happy storing this in a Numeric 9,3 column.

When trying to read this in .NET, you get this message:

System.InvalidOperationException

The provider could not determine the decimal value. blah, blah, blah...

The question then is - is there a work-around? I can find no way to force .NET to use greater precision. About all I can come up with is to catch the exception and return a nice error message asking the user to make the column larger in VFP.

Here's the .NET code, thanks in advance

Mike



string sqlString = "SELECT * FROM " + Path.GetFileName(dbfFullPath);

OleDbConnection oleConn = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=" +

folderName + ";Collating Sequence=MACHINE;");

OleDbCommand oleCmd = new OleDbCommand(sqlString, oleConn);

OleDbDataReader oleReader;

try

{

oleConn.Open();

oleReader = oleCmd.ExecuteReader();