OleDbDataAdapter.Fill throws an error (DB_E_BADROWHANDLE) when .NET 2.0 is installed.

  • Thread starter Thread starter Johnny
  • Start date Start date
J

Johnny

When I use the OleDbDataAdapter.Fill to fill a DataSet with a
ADODB.Recordset an error occurs ("No error message available, result
code: DB_E_BADROWHANDLE(0x80040E04)."

If only the .NET Framework 1.1 is installed everything works fine.

What's wrong (or changed)?
 
Hi
The same problem for me too.
Any one can help us

My source code is as follows

Dim adCnn As New ADODB.Connection

Dim adRec As New ADODB.Recordset

adCnn.ConnectionString = strCnn

adCnn.Open()

adRec.ActiveConnection = adCnn

Dim strSelect As String = "SELECT IdmId FROM FnDocument"


adRec.Open(strSelect, , ADODB.CursorTypeEnum.adOpenKeyset, ADODB.
LockTypeEnum.adLockReadOnly)

MsgBox(adRec.RecordCount.ToString)

Dim adapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter

Dim dtTable As New DataTable

adapter.Fill(dtTable, adRec)
 
Back
Top