ADO Query problem

Hi, all!

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.

What is the problem?

Thank you!
Ivo


.

Relevant Pages

  • Re: Operator in SQL like "Like"
    ... I have an Access database with a table called "product". ... The SQL that Access gives me for the query I am trying ... All of the operators used in Microsoft Jet SQL ... So it may be that the Like operator for Access SQL cannot be used in Delphi. ...
    (microsoft.public.access.modulesdaovba)
  • ANSI defaults, Linked Server
    ... Access database that our Credit Card processing software uses. ... written a SP to grab some data from this Linked Server, and from my local SQL ... Enable these options and the reissue your query" ...
    (microsoft.public.sqlserver.programming)
  • Re: Running a Query
    ... in your "code" (it's called a SQL statement, ... query in design view. ... the SQL is presented in the query grid. ... >> is the Members table in the Access database where you're building the ...
    (microsoft.public.access.queries)
  • Pass-Through, Default DSN?
    ... I am converting my companies Access database to SQL ... as a front end to connect to SQL Server. ... Through query so it connects to the ODBC to run the query, ...
    (microsoft.public.access.queries)
  • RE: How to simple retrieve autonumber valuees or identity from data so
    ... you can write the equivalent of a stored procedure in Access. ... Simply write your SQL in a query and save it. ... > I use the access database in my simple application. ...
    (microsoft.public.dotnet.framework.adonet)