Mysql Ado Delphi 7 - Table does not exist

marcos

Delphi Developer

Sat, 30 Jul 2005 19:54:10 GMT

Mysql Ado Delphi 7 - Table does not exist

Hi people.
I'm with a problem using MySQL version 3.23.49 with Delphi 7.0 and
package ADO (ADOConnection, ADOQuery and ADOQuery.provider= MySqlProv.3.0).
MySQL tables with field datatype "TEXT", when i try OPEN then ADOQuery
received "Table does not exist".

Thanks and good luck for all.

Barry Clar

Delphi Developer

Sat, 30 Jul 2005 23:07:25 GMT

Re:Mysql Ado Delphi 7 - Table does not exist

Initially I had to use version 3.5 of MySQL ODBC and set up ADO to point to
that , and that was flaky, especially on updates. Eventually I went for the
MySQLDAC components which talk directly to MySQL and work a treat

http://www.microolap.com/products/dac/mysqldac.htm

Barry

Dr Barry Clark
Senior Lecturer & IT Systems Designer
Medical Education Unit
Wolfson Medical Building
University of Glasgow
Glasgow G12 8QQ
Tel: 0141-330-4248
Email: b.cl...@clinmed.gla.ac.uk

Quote

"marcos" <mkiy...@promaster.com.br> wrote in message

news:3e48d64e$1@newsgroups.borland.com...

Quote

> Hi people.
> I'm with a problem using MySQL version 3.23.49 with Delphi 7.0 and
> package ADO (ADOConnection, ADOQuery and ADOQuery.provider=
MySqlProv.3.0).
> MySQL tables with field datatype "TEXT", when i try OPEN then ADOQuery
> received "Table does not exist".

> Thanks and good luck for all.

marco

Delphi Developer

Sun, 31 Jul 2005 01:35:41 GMT

Re:Mysql Ado Delphi 7 - Table does not exist

Thanks Dr. Barry, but the project was structured to use ADO and anothers
databases and i can't leave the ADO package , i founded informations about
this problem in a lot of delphi sites and no one help.

Thanks again.

"Barry Clark" <b.cl...@clinmed.gla.ac.uk> escreveu na mensagem
news:3e49119a$1@newsgroups.borland.com...

Quote

> Initially I had to use version 3.5 of MySQL ODBC and set up ADO to point
to
> that , and that was flaky, especially on updates. Eventually I went for
the
> MySQLDAC components which talk directly to MySQL and work a treat

> http://www.microolap.com/products/dac/mysqldac.htm

> Barry

> --

> Dr Barry Clark
> Senior Lecturer & IT Systems Designer
> Medical Education Unit
> Wolfson Medical Building
> University of Glasgow
> Glasgow G12 8QQ
> Tel: 0141-330-4248
> Email: b.cl...@clinmed.gla.ac.uk
> "marcos" <mkiy...@promaster.com.br> wrote in message
> news:3e48d64e$1@newsgroups.borland.com...
> > Hi people.
> > I'm with a problem using MySQL version 3.23.49 with Delphi 7.0 and
> > package ADO (ADOConnection, ADOQuery and ADOQuery.provider=
> MySqlProv.3.0).
> > MySQL tables with field datatype "TEXT", when i try OPEN then
ADOQuery
> > received "Table does not exist".

> > Thanks and good luck for all.

Other Threads

1. Mysql Ado Delphi 7 - Table does not exist - HELP ME AGAIN

2. Blob Ado Mysql => Not working properly

3. ADO Update ERROR : Row does not exists

4. DbExpress + MySql / ADO + MySql

5. Table Does Not Exist

6. RequestLive gives "Table does not exist"

7. btrieve - table does not exist

8. TQuery problem -- 'Table Does Not Exist'

9. TQuery: Table does not exist LIES!

10. ORA-00942 Table or View does not exist