Re: ADO Query problem
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Wed, 25 May 2005 21:13:35 -0500
>I'm using Delphi 7.1 and ADOConnection to Access database (.mdb)
>(Provider=Microsoft.Jet.OLEDB.4.0)
>Connection is OK.
>
>I Create a table "Coach" (in Ms Access ) with one column name as
>Position(text datatype)
>
>Then I create an instance of TADOQuery with the following SQL:
>SELECT
> Coach.Position
>FROM
> Coach
>
>When I try to open this Query I get an EOLEException with message
>'Unspecified eroor'.
>
>In Access 2003 there is no problem to execute this query.
>There is no problem with ODBC too.
Do you have a lookup field defined for this dataset?
Lookupfields will trigger an error like this when you run out of the IDE.
This error will not occur outside the IDE or if you set the Lookupcache property
to true
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- ADO Query problem
- From: Ivelin Salabashev
- ADO Query problem
- Prev by Date: Re: D2005 ADO problem: multiple-step OLE DB operation generated errors
- Next by Date: Re: D2005 ADO problem: multiple-step OLE DB operation generated errors
- Previous by thread: Re: ADO Query problem
- Next by thread: Don't want to delete from secondary table
- Index(es):
Relevant Pages
|
