Tell me what you do
ADODB -> OLEDB driver for ODBC -> MyODBC -> MySQL
ADODB -> MyOLEDB -> MySQL
or anything else?
first case: check "don't promt on connect"
Did you create a data source? (First thing you don't need to do...)
But whatever you do with VB, MS ADODB and MySQL - you will need
select id, product, min(price), store from tablename group by product
Better?
Regards
Chris
- Original Message -
From: "Ciprian Trofin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 1:24 PM
Subject: Re[2]: Join or smth.
> Doesn't work the way I want
select * from table_name where product like 'p1' order by price limit 1;
- Original Message -
From: "Ciprian Trofin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 11:20 AM
Subject: Join or smth.
> I have a table that looks smth. like this:
>
> id prod
take a look in the user table (database mysql). There should be a row like
this...
HostUserPassword
localhost root ...
means that the user root can connect from localhost (the mysql server) only.
replace localhost by % or (better) insert a new row
%
s.update
...
ERROR: Row cannot be located for updating. Some values may have been changed
since it was last read.
Any suggestions? Or does anyone know where I can find more information about
MySQL and ADO?
Thanks,
Christoph Lütjen
