problem to show unicode data loading from dbf file with Microsoft.Jet.OLEDB.4.0, when BDE (borland database engine) is installed

Question

Hello

i write a code that show dbf file (foxpro 2.6 database) unicode record to datagridview

my connection string is:

Dim strCnnA As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.dbf;Extended Properties=dBASE III;"

dim ConnA As New OleDb.OleDbConnection

ConnA = New System.Data.OleDb.OleDbConnection(strCnnA)

***

when i load data to datagridview (vb.net) , It's all good

But when I installed the Borland Database Engine on my system (bde for other software I need) , the unicode data on my grid Becomes corrupted.

then

1- If you want to remove BDE, everything will be ok

2- if you rename BDE (for example BDEold) at bellow address , everything will be ok

C:\Program Files (x86)\Borland\Common Files\BDE

why ?

Answer 1

Hello,

For this issue regarding Borland Database Engine, I would like suggest you post it to:

http://community.microfocus.com/

Regards.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

See if the below link helps:

How to control whether Access loads the Borland Data Engine (BDE)

From what I can determine BDE does not support unicode and was deprecated many years ago by Embarcadero. Since unicode support for FoxPro was rather problematic I would recommend upgrading to a different database, such as Microsoft Access, SQL CE or SQLite. FoxPro is also considered deprecated technology so I would definitely consider moving away from that platform.

---

Paul ~~~~ Microsoft MVP (Visual Basic)