I would like to know as to what has been the experience of using direct data access components like devart's MyDAC which allows a direct connection to the mysql server rather than through the client library or ODBC.
A:
I've never used MyDAC before. My experience is with DAC for MySQL from http://www.microolap.com/.
So far so good. Pretty easy to drop onto my Delphi projects, set the values of various properties, and then ready to connect. It has quite a number of useful components that allows you to retrieve data in several ways and you can use it easily with TDataSource.
No issues with deployment as well. All compiled nicely into one EXE.
Hope this helps!
SharkMan
2010-06-15 03:42:26
A:
Mydac is the best when you try to connect to MySql, it's fast stable and real powerful components.
Also the same for other components like Sdac and Odac.
and if you would like to use more than database you can use Unidac, which you can use to connect to (oracle, Sql server, Mysql, Interbase, Firebird and ODBC drivers.).
Another great point for Devart components that you don't need client library to be installed on the clients machine (libmysql.dll).
Mohammed Nasman
2010-06-15 06:32:07
I believe bypassing the standard DB client library is often a minus, not a plus, unless you have a very good reason to do so. You rely wholly on a third party implementation that could have flaws, especially security ones, and may be less tested and updated than the standard client, and not implementing all the available features. At least the MySQL protocol is open source, but others DB may not, and I would be very careful to choose that approach just to simplify deployment.
ldsandon
2010-06-15 08:01:38
ldsandon, I have using MyDac and Odac with direct mode since years, and never faced any problem, DevArt is good company to rely on, maybe you are right for other components.
Mohammed Nasman
2010-06-15 09:00:44
Am thinking of using MyDAC for accessing MySQL Server
Vinayak Mahadevan
2010-06-15 09:55:32