locked
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.
    Monday, April 30, 2007 7:23 AM

All replies

  • 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
    Friday, August 10, 2007 3:35 PM
  • 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
    Tuesday, May 17, 2011 7:35 AM
  • Thanks it working for me :)
    Friday, September 14, 2012 4:54 PM