BUG: Error When You Select an Empty Visual FoxPro Memo Field Using .NET OleDbDataAdapter and Visual FoxPro OLE DB Provider (326544)

MORE INFORMATION

Steps to Reproduce the Behavior

1. In Visual Studio .NET, create a new Microsoft Visual Basic .NET Console Application project.
2. Replace the default Module1 code with the following:

   Imports System.Data.OleDb
   
   Module Module1
   
       Sub Main()
           ' Demonstrates a problem with the Microsoft OLE DB Provider for Visual FoxPro
           ' interacting with the OleDbDataAdapter object and empty FoxPro memo fields.
           Dim ThisDir As String = System.AppDomain.CurrentDomain.BaseDirectory
           Dim oConn As New OleDbConnection("Provider=VFPOLEDB.1;Data Source=" & ThisDir)
           Dim oCMD As New OleDbCommand()
           Dim oDA As New OleDbDataAdapter("SELECT fldMEMO FROM Q326544", oConn)
           Dim oDS As New DataSet()
   
           ' Create a Visual FoxPro table with one memo field, and then insert a blank record.
           With oCMD
               .Connection = oConn
               .Connection.Open()
               .CommandType = CommandType.Text
               .CommandText = "CREATE TABLE Q326544 (fldMEMO M)"
               .ExecuteNonQuery()
               .CommandText = "INSERT INTO Q326544 VALUES ([])"
               .ExecuteNonQuery()
               .Connection.Close()
           End With
   
           Try
               oDA.Fill(oDS)
           Catch oER As Exception
               MsgBox(oER.Message)
           End Try
   
           oDA.Dispose()
           oConn.Close()
           oConn.Dispose()
           oCMD.Dispose()
       End Sub
   End Module
   					

3. Press F5 to run the project.