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

  • 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 ?





    • Edited by Ashkan209 Tuesday, May 6, 2014 4:27 AM
    • Moved by Fred Bao Friday, May 16, 2014 3:19 AM Borland Database Engine Related
    Tuesday, May 6, 2014 3:42 AM

All replies

  • 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.

    Wednesday, May 7, 2014 5:34 AM
  • 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)

    Wednesday, May 7, 2014 12:45 PM