Groups | Blog | Home
all groups > dotnet ado.net > may 2006 >

dotnet ado.net : OleDbDataAdapter.Fill throws an error (DB_E_BADROWHANDLE) when .NET 2.0 is installed.


Johnny
5/31/2006 7:41:38 AM
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)?
Alokkan
8/23/2006 6:39:41 AM
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

AddThis Social Bookmark Button