IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Question

---

i have written a code:

Dim cn As OleDbConnection
        cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My.Application.Info.DirectoryPath & "\DATABASE\medicaldb.mdb" & ";")
dim strquery as string
 strquery = "SELECT * FROM  bilpass NATURAL INNER JOIN advance"
        Dim cmd As New OleDbCommand(strquery, cn)
        Dim da As New OleDbDataAdapter(cmd)
        Dim ds As New DataSet
        da.Fill(ds)
        DataGrid1.DataSource = ds.Tables(0)


'bilpass' and 'advance' are access database tables. i have to perform natural inner join on the 2 tables. but
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

error crops up.

i have to display the result of query on datagrid.
what is the problem and how can it be solved?

thanks.

Answer 1

Hello

I faced a similar problem and it looks like this happens when you type a reserved word in the statement.
Try to enclose the table's name with [ ] , like [advance].

Hope that helps,
Elias

Answer 2

Hello

I faced a similar problem and it looks like this happens when you type a reserved word in the statement.
Try to enclose the table's name with [ ] , like [advance].

Hope that helps,
Elias

code work for me

Answer 3

Thanks it working for me :)