I just installed 0.9.14-1, it's true that the sqldb components are pre-installed. However, there are only 6 components on the last tab the 6th one being TPQConnection. There is only 1 MySQLConnection. Is there something else I have to do to get it to install with the 3 components you mention? MySQL 5.0 is installed on my machne. I'm running on Windows XP SP2.
I got it to "work" with some creative "borrowing" from Martin Schreiber's components and recompiling Lazarus. But I don't have distinct icons for the the three connections.
In any event, TMySQLQuery appears to be broken in FP 2.0.2 at least for version 5.0 connections. In particular "select * from mytable" only populates the fielddef property with some of the field types.
I've download the latest snapshot and will try it, but since the Windows version hasn't been updated since Apr 02, I'm not optimistic.
O.K. there are three Connections all with same icon. With a connection50, transaction, query, datasource, and dbgrid, on a form in the designer, connecting appears to work.
The table being selected has fields with the following attributes:
fld1 char(4), fld2 char(2), fld3 char(20), fld4 through fld7 decimal(7,3), fld8 char(1), fld9 decimal(2,0)
select fld1, fld2, fld3, fld8 from mytable order by fld1, fld2 works fine
select * from mytable order by fld1, fld2 causes "list index(7) .." errors and eventually kills lazarus.