connect to Mysqli

[Regany]

Could someone advise some componenet or other way to connect and retrieve data from Mysqli?

 

[pwesson]

I use DAC for MySQL from:

http://www.microolap.com/products/connectivity/mysqldac/

Paul Wesson, Programmer/Analyst

http://www.ipaw.net

 

[gcaramia]

I use Mydac components from CoreLab

http://crlab.com/mydac/

they connect directly to MySql without DLL/ODBC...

Giovanni Caramia

 

[Delphard]

Giovanni,
I visit their web page and that seems pretty interesting, but, before I buy them, tell me few words about Mydac components: what is main improvements with Mydac components compared with ADO or some other approach? Any perceptible speed gains? Are all features of MySQL supported?
Thanks in advance!

 

[gcaramia]

Connection speed, before all.
As i said, you can connect directly to mysql (all server versions; now i'm using 5.0.4) or, if you prefer, throw libmysql.dll or configuring ODBC (download MyODBC from MySQL.com)
I use direct connection (default one) so i don't configure ODBC on clients, nor distribute any dll; your .exe is all.

- Drug on your form 'connection component' and configure it for your database (host, user, password, databaseName); but this component has a lot of other tuning possibilities (as example: to use compression if your host is over internet, this increase a lot transfer data)

- Drug on your form 'sqlquery component', link it to 'connection component' and write your query.
- Using 'datasource component' ......

This is all the basic but there is a lot more (command query, tables, stored procedure for mysql 5.0, update query, dump, backup server, monitor server, virtual table.....)

I advice you to download trial version and try it. You will be able to use immediatly, i'm sure.

I use mydac since 2 years and i never had any problem.

I hope this can help you
Giovanni Caramia