ADO.NET OleDB and very old dBASE IV file

Question

i'm reading DBF file using OleDb this way :

[TestMethod]
public void TestMethod2()
{
  const string path = @"D:\VL816183.DBF";

  var connection = new OleDbConnection(string.Format("Provider=Microsoft.Jet.Oledb.4.0;Data Source={0};Extended Properties=\"dBase IV\"", Path.GetDirectoryName(path)));
  connection.Open();

  var command = new OleDbCommand(string.Format("select MNO from {0}", Path.GetFileName(path)), connection);

  using (var reader = command.ExecuteReader())
  {
    while (reader.Read())
    {
      var str = (string)reader["MNO"];

    }
  }

  connection.Close();
}

Everything seems to be OK but there's problem with string data. The source database contains strings saved with CodePage=852 and I can't find way to properly read it.

I've tried to set CharSet/CodePage/CharacterSet into the connection string's extended properties but without any luck (in fact, exception was thrown: Couldn't find installable ISAM).

I've also tried to read it using 'vfpoledb' provider, still no luck.

For example there's string "FRANTIŠEK" but the str variable contains "FRANTIµEK".

Does anybody know how to do it ? Thanks

can you do it by `Field Index` instead of the Field name using reader — MethodMan, Mar 26 '13 at 15:07
Check this link out that code means that something is not configured correctly http://www.oocities.org/geoff_wass/dBASE/GaryWhite/dBASE/FAQ/qcp.htm | http://www.cs.cmu.edu/~varun/cs315p/xbase.txt | http://www.manmrk.net/tutorials/database/xbase/dbf.html — MethodMan, Mar 26 '13 at 15:26

score 3 · Accepted Answer · answered Mar 27 '13 at 06:28

Well, after few hours I've managed to get strings in proper way. The trick is in reading string columns as varbinary(length) :

[TestMethod]
public void TestMethod2()
{
  const string path = @"D:\KN_Vzorka_2012\VL816183.DBF";

  var connection = new OleDbConnection(string.Format("Provider=vfpoledb;Data Source={0};Extended Properties=\"dBase IV\";Locale Identifier=852;", Path.GetDirectoryName(path)));
  connection.Open();

  var command = new OleDbCommand(string.Format("select cast(MNO as varbinary(20)) as MNO FROM {0}", Path.GetFileName(path)), connection);

  using (var reader = command.ExecuteReader())
  {
    while (reader.Read())
    {
      var arr = (byte[])reader["MNO"];
      var str = Encoding.GetEncoding(852).GetString(arr);

    }
  }

  connection.Close();
}

The only one problem is with the length inside varbinary CAST. But it works. Hope this helps someone too.

I should add that in this answer a different provider was used. CASTing does not work in "Microsoft.Jet.Oledb.4.0" but works in Visual Fox Pro provider "vfpoledb". — Mirek, Nov 27 '13 at 13:54

score 1 · Answer 2 · answered Mar 26 '13 at 15:26

1

You can specify the locale identifier in the connection string. Try editing your connection string text to the following:

"Provider=Microsoft.Jet.Oledb.4.0;Data Source={0};Extended Properties=\"dBase IV\";Locale Identifier=852;"

answered Mar 26 '13 at 15:26

Jake H

1,720
1
12
13

ADO.NET OleDB and very old dBASE IV file

2 Answers2