471,066 Members | 1,300 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

ODBC 3.51 + ADO + MySQL Solaris server -> Unwanted Select * from..

JB
Hey ppl,

I'm experiancing a very weird problem with my current Win32(win2k/XP)
application.

I'm using:

* Delphi 7
* ADO
* mySQL ODBC 3.51 drivers
* connecting to a Solaris server with MySQL 3.23.36
* Table type MyISAM, Dynamic row format

When I perform the following basic query:

select count(*)
from table
where (field=value)

the following is communicated between client and database server
(sniffed with ethereal):

C->S

select count(*)
from table
where (field=value)

S->C

result

C->S

Select * from table

S->C

result

This ofcourse is fully unwanted (with 30.000 records and 20 fields in
the table)! When performing the query the following way:

select count(*)
from `table`
where (field=value)

the second unasked query (select * from table) is not performed.

WHY??? My Quess it is something in the ODBC drivers, since the client is
sending the request for the second query, however, when connecting to a
mysql (4) NT server this behavour is not seen.

I've now updated all my queries to use the '`' with table names,
however, i'm sometimes still experiancing this weird behaviour, any
clues would be very very very welcome. Since this screws up my
application pretty badly.

ThePriest
Jul 20 '05 #1
0 1362

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Hal Halloway | last post: by
4 posts views Thread by Audrius | last post: by
2 posts views Thread by David | last post: by
2 posts views Thread by Beda Christoph Hammerschmidt | last post: by
4 posts views Thread by Bob Sanderson | last post: by
1 post views Thread by shan_rish | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.