Data Access Components for MySQL (MyDAC)

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Provide direct high performance access to MySQL. Data Access Components for MySQL (MyDAC) is a set of nonvisual components for Borland Delphi, C++ Builder and Kylix. It provides direct high performance access to MySQL and is an alternative to the standard way of accessing databases using BDE or dbExpress. MyDAC provides the ability to work with a MySQL server without the client library and access to an embedded server. Working without the client, MyDAC uses native MySQL protocol and requires only TCP/IP. MyDAC supports new MySQL server versions and all available data types.

From

$127.35

Price in USD ($) - US Dollar GBP (£) - Pound Sterling EUR (€) - Euro JPY (¥) - Japanese Yen AUD (A$) - Australian Dollar KRW (￦) - Korean Won BRL (R$) - Brazilian Real TWD (NT$) - New Taiwan Dollar SGD (S$) - Singapore Dollar SEK (SKr) - Swedish Kronor NZD (NZ$) - New Zealand Dollar NOK (NKr) - Norwegian Krone MXN (MX$) - Mexican Peso INR (Rs) - Indian Rupee HKD (HK$) - Hong Kong Dollar DKK (DKr) - Danish Krone CNY (元) - Chinese Yuan Renminbi CHF (CHF) - Swiss Franc CAD (Can$) - Canadian Dollar ZAR (R) - South African Rand

Our regular prices are shown below. Please logon to see your discounted prices.

Data Access Components for MySQL (MyDAC) V5.70 Standard

Add to Cart	$ 127.35	1 Developer License - Standard Edition - with Subscription		Download (38.4 MB)
Add to Cart	$ 293.95	4 Developer Team License - Standard Edition - with Subscription		Download (38.4 MB)
Add to Cart	$ 538.95	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - with Subscription		Download (38.4 MB)

Data Access Components for MySQL (MyDAC) V5.70 Professional

Add to Cart	$ 195.95	1 Developer License - Professional Edition - with Subscription		Download (40.7 MB)
Add to Cart	$ 39.15	1 Developer License - Professional Edition Upgrade from Standard V4.x - with Subscription	Verify	Download (40.7 MB)
Add to Cart	$ 68.55	1 Developer License - Professional Edition Upgrade from Standard V5.x - with Subscription	Verify	Download (40.7 MB)
Add to Cart	$ 489.95	4 Developer Team License - Professional Edition - with Subscription		Download (40.7 MB)
Add to Cart	$ 881.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition - with Subscription		Download (40.7 MB)

Data Access Components for MySQL (MyDAC) V5.70 Professional with Source code

Add to Cart	$ 293.95	1 Developer License - Professional Edition with Source code - with Subscription		Download (43.4 MB)
Add to Cart	$ 685.95	4 Developer Team License - Professional Edition with Source code - with Subscription		Download (43.4 MB)
Add to Cart	$ 1,273.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Professional Edition with Source code - with Subscription		Download (43.4 MB)

Data Access Components for MySQL (MyDAC) V5.70 Developer

Add to Cart	$ 244.95	1 Developer License - Developer Edition - with Subscription		Download (55.4 MB)
Add to Cart	$ 587.95	4 Developer Team License - Developer Edition - with Subscription		Download (55.4 MB)
Add to Cart	$ 1,077.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Developer Edition - with Subscription		Download (55.4 MB)

Data Access Components for MySQL (MyDAC) V5.70 Developer with Source code

Add to Cart	$ 342.95	1 Developer License - Developer Edition with Source code - with Subscription		Download (55.4 MB)
Add to Cart	$ 783.95	4 Developer Team License - Developer Edition with Source code - with Subscription		Download (55.4 MB)
Add to Cart	$ 1,469.95	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Developer Edition with Source code - with Subscription		Download (55.4 MB)

Data Access Components for MySQL (MyDAC) Standard Subscription Renewal

Add to Cart	$ 39.15	1 Developer License - Standard Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 97.95	4 Developer Team License - Standard Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 176.35	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Standard Edition - Subscription Renewal	Verify	Download (29 KB)

Data Access Components for MySQL (MyDAC) Professional Subscription Renewal

Add to Cart	$ 58.75	1 Developer License - Professional Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 137.15	4 Developer Team License - Professional Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 244.95	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Professional Edition - Subscription Renewal	Verify	Download (29 KB)

Data Access Components for MySQL (MyDAC) Professional with Source code Subscription Renewal

Add to Cart	$ 117.55	1 Developer License - Professional Edition with Source code - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 235.15	4 Developer Team License - Professional Edition with Source code - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 489.95	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Professional Edition with Source code - Subscription Renewal	Verify	Download (29 KB)

Data Access Components for MySQL (MyDAC) Developer Subscription Renewal

Add to Cart	$ 78.35	1 Developer License - Developer Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 176.35	4 Developer Team License - Developer Edition - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 342.95	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Developer Edition - Subscription Renewal	Verify	Download (29 KB)

Data Access Components for MySQL (MyDAC) Developer with Source code Subscription Renewal

Add to Cart	$ 137.15	1 Developer License - Developer Edition with Source code - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 313.55	4 Developer Team License - Developer Edition with Source code - Subscription Renewal	Verify	Download (29 KB)
Add to Cart	$ 587.95	1 Site Wide License (Allows Unlimited Developers at a Single Company) - Developer Edition with Source code - Subscription Renewal	Verify	Download (29 KB)

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What’s new in Data Access Components for MySQL (MyDAC) V5.70?

• Delphi 2009 and C++Builder 2009 supported
• Extended Unicode support for Delphi 2007 added (special Unicode build)
• Free Pascal 2.2 supported
• Powerful design-time editors implemented in Lazarus
• Completed with more comprehensive structured Help

What’s new in V5x?

New functionality:

• Delphi 2007 for Win32 supported
• Disconnected model for working offline and automatically connecting and disconnecting supported
• Local failover for detecting connection loss and implicitly reexecuting some operations supported
• SSH protocol supported via CryptoLibrary component set
• Added DataSet Manager to control project datasets
• Integration with MySQL Developer Tools 2.00 added
• New component for transferring data between all types of TDataSets descendants added
• Output parameters from stored procedures and functions retrieval supported
• Data export and import to/from XML supported
• WideMemo field type in Delphi 2006 supported
• AutoRefresh mode support added
• Option to break long-duration query execution added
• Ability to search for installed MySQL servers on the network added
• Support for sending messages to DBMonitor from any point of your program added

Support for more MySQL server functionality:

• HANDLER syntax support in TMyTable added
• Enumeration values retrieval for the ENUM and SET fields added

Extensions and improvements to existing functionality:

• General performance improved
• Master/detail functionality extensions:
  • Local master/detail relationship support added
  • Master/detail relationship in CachedUpdates mode support added
• TMyScript component improvements:
  • Support for executing individual statements in scripts added
  • Support for executing huge scripts stored in files with dynamic loading added
  • Ability to use standard MySQL client tool syntax added
• Working with calculated and lookup fields improvements:
  • Local sorting and filtering added
  • Record location speed increased
  • Improved working with lookup fields
• Greatly increased performance of applying updates in CachedUpdates mode
• Connection pool functionality improvements:
  • Efficiency significantly improved
  • API for draining the connection pool added
• Option to ignore or replace records with duplicated key values in TMyLoader added
• Enhanced TMyServerControl functionality for working with server values
• Ability to customize update commands by attaching external components to TMyUpdateQuery objects added

Usability improvements:

• Syntax highlighting in design-time editors added
• Demo projects became better organized and clearer

Overview
Data Access Components for MySQL (MyDAC) library offers a set of nonvisual components for Borland Delphi, C++ Builder and Kylix. They provide access to MySQL database and are an alternative to a standard way of accessing databases using Borland Database Engine (BDE) or dbExpress.

MyDAC can work using MySQL client or native MySQL network protocol. In case of using MySQL protocol directly MyDAC doesn't require client library and requires only TCP/IP protocol. This feature allows you to build really thin database application. MyDAC can work in managed environment and supports .NET Framework.

Following the main features of Data Access Components for MySQL (MyDAC):

• Direct access to MySQL data. No distributing, installing and configuring the BDE and ODBC
• Doesn't require MySQL's software on the client side with Direct option and works directly through TCP/IP
• Supports the latest versions of MySQL server
• All MySQL data types supported
• Supports MySQL specific features
• High performance controlled fetching of large data blocks
• Optimized string and binary data storing
• Automatic data updating with TMyQuery and TMyTable components
• Automatic record refreshing
• MySQL Embedded server support
• Connection pooling feature
• Stored procedures support
• Support for compression protocol
• Unicode and national charsets support
• Encrypted SSL connections support
• BLOB compression support added
• TMyScript component to execute scripts
• TMyLoader component for fast loading data
• Separated run-time and GUI specific parts allow to create pure console applications such as CGI
• Advanced design-time editors
• MySQLBuilder Add-in extends design-time capabilities by set of tools to build and check queries
• Extended SQL tracing capabilities provided by the TMySQLMonitor component and the DBMonitor application
• Includes source code of TCRDBGrid enhance data-aware grid control
• Wide data-aware and reporting components support, including InfoPower, ReportBuilder, FastReport
• Easy migration from BDE with Migration Wizard
• Allows to use Professional Edition of Delphi, C++ Builder or Kylix to develop client/server applications

MyDAC Editions

My Data Access Components comes in three editions: MyDAC Standard Edition, MyDAC Professional Edition and MyDAC Developer Edition. MyDAC Standard Edition includes the MyDAC basic connectivity components and the MyDAC Migration Wizard. MyDAC Professional Edition includes additional components and DataSet Manager. MyDAC Developer Edition is a bundle package of MyDAC Professional Edition with MySQL Developer Tools, an advanced add-in for MySQL database development and administration.

Standard

• Base Components - (TMyConnection, TMyQuery, TMyCommand, TMyTable, TMyStoredProc, TMyUpdateSQL, TMyConnectDialog, TMySQLMonitor, TMyScript, TMyDataSource, TVirtualTable, TCRDBGrid, MyDataAdapter
• Design-time features, including component editors and property editors
• Migration Wizard

Professional

• Base Components  - (TMyConnection, TMyQuery, TMyCommand, TMyTable, TMyStoredProc, TMyUpdateSQL, TMyConnectDialog, TMySQLMonitor, TMyScript, TMyDataSource, TVirtualTable, TCRDBGrid, MyDataAdapter
• Additional Components - (TMyLoader, TMyDump, TMyBackup, TMyServerControl, TMyEmbConnection, TMyBuilder, TCRBatchMove)
• Design-time features, including component editors and property editors
• DataSet Manager
• Migration Wizard

Developer

• Base Components  - (TMyConnection, TMyQuery, TMyCommand, TMyTable, TMyStoredProc, TMyUpdateSQL, TMyConnectDialog, TMySQLMonitor, TMyScript, TMyDataSource, TVirtualTable, TCRDBGrid, MyDataAdapter
• Additional Components - (TMyLoader, TMyDump, TMyBackup, TMyServerControl, TMyEmbConnection, TMyBuilder, TCRBatchMove)
• Design-time features, including component editors and property editors
• DataSet Manager
• Migration Wizard
• My Developer Tools