MySQL Forums - Delphi Forum for MySQL and Delphi. http://forums.mysql.com/list.php?49 Wed, 22 May 2013 23:08:46 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?49,585102,585102#msg-585102 The new versions of DAC products with support for Rad Studio XE4, iOS and the NEXTGEN compiler (no replies) http://forums.mysql.com/read.php?49,585102,585102#msg-585102 http://www.devart.com/dac.html users receive an update that will greatly expand their development potential.

The whole product line has evolved significantly and got the following new features:
- The latest Rad Studio XE4 support gives users the opportunity to develop applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64, Mac OS, and iOS.
- The capability to establish connection to the most popular databases from iOS. From now, whether you run an application on iPhone/iPad or debug it in iOS Simulator, Devart Delphi Data Access Components will always grant an unrivalled opportunity to establish Direct Connection and get the fastest data access to such databases as Oracle and MySQL.
- Full support for NEXTGEN compiler. Now Delphi Data Access Components can be universally used when developing DB-applications using Automatic Reference Counting or any other features of the new NEXTGEN compiler.
- Support for FPC 2.6.2 and Lazarus 1.0.8

And that is just the beginning of the list as the new versions also comprise many general performance improvements which are meant to facilitate developers' work and make it even more efficient as we appreciate and value the time of each and every of our users.

Feedback on the new versions would be highly appreciated, share your ideas via the UserVoice or visit Devart Forum to ask a new question or join the discussion.

For additional information about Devart, visit http://www.devart.com/.]]> Ирина Писклярова Delphi Mon, 29 Apr 2013 12:51:55 +0000 http://forums.mysql.com/read.php?49,584155,584155#msg-584155 dbExpress drivers are the new members of Devart High Five Program (no replies) http://forums.mysql.com/read.php?49,584155,584155#msg-584155
You can get really valuable discounts on dbExpress drivers by publishing products' reviews in your blogs, websites, forums and other resources.
For additional detailed information about our discount program you can visit HighFive Program's page - http://www.devart.com/highfive/highfive-dbx.html]]> Ирина Писклярова Delphi Wed, 17 Apr 2013 12:33:27 +0000 http://forums.mysql.com/read.php?49,584010,584010#msg-584010 SQLDataSet not connecting with MySQL server (no replies) http://forums.mysql.com/read.php?49,584010,584010#msg-584010 I have a major problem with Delphi datamodule and the MySQL database.

I have created a Datamodule in Delphi 2010. The SQLConnection object had no problem connecting to my database (MySQL database). However the SQLDataset object does not want to connect to the Database. As soon as I set the Command Type property to ctTable and want to select the table for the Command Text i get the error message "Access denied for user 'root'@'localhost' (Using password:YES)" I have uninstalled and reinstalled MySQL Workbench CE. I have google the error and it seems like the object cannot connect to the MySQL server.

Does anyone have a solution for me on this I ran out of ideas.]]> Izak du Toit Delphi Mon, 15 Apr 2013 08:34:19 +0000 http://forums.mysql.com/read.php?49,581421,581421#msg-581421 Question to all, suggestion to forum admins (no replies) http://forums.mysql.com/read.php?49,581421,581421#msg-581421
Lazarus is the Delphi-inspired open source alternative to making Embacarado rich.

The Lazarus site claims good support for MySQL, and I suspect that many "Lazarus/MySQL" questions have the same answer as an equivalent "Lazarus/Delphi" question.

Pending responses from experience MySQL people, perhaps the forum title could be extended to "Delphi and Lazarus"? Or at least maybe Lazarus could appear in the forum description, to help search engines help their users find the forum?

http://wiki.freepascal.org/mysql]]> Sheep dog Delphi Fri, 15 Mar 2013 10:25:15 +0000 http://forums.mysql.com/read.php?49,576249,576249#msg-576249 New Versions of Delphi Data Access Components and VirtualTable with Rad Studio XE 3 Update 1 and C++Builder 64-bit support (no replies) http://forums.mysql.com/read.php?49,576249,576249#msg-576249
The new versions of Devart products support Rad Studio XE 3 Update 1 and C++Builder 64-bit are released. If earlier Devart Data Access Components allowed application development for Win32 and Mac OS X, now, using our Delphi components and C++Builder 64-bit, you can create native database applications for Win64 as well.
For more information on new release - http://www.devart.com/news/2012/dacx611.html]]> Marina Nastenko Delphi Tue, 18 Dec 2012 14:44:01 +0000 http://forums.mysql.com/read.php?49,573919,573919#msg-573919 equal to the largest item in the DB :( - or 255 bytes long (no replies) http://forums.mysql.com/read.php?49,573919,573919#msg-573919 Americas Next Top Model Season 19 Episode 12 In judging, London's photo received unanimously great praise, mainly because she managed to smile wide without looking cheesy and because she found her photographer while also finding her light at the same time. However, her not-so-model presence at the judging panel dragged the judges' choice down a bit. Allison, Celia and Fo also received praise, but Sandra, Nikita Season 3 Episode 5 Isabella, Tahlia, and Jessica struggled to make it work. Near the end, Allison was the first to have her picture displayed as digital art in the house. The bottom two came down to Isabella and Sandra, where, despite Sandra's poor performances on the runway and in the photo shoot, Isabella was eliminated for having a weaker Grimm Season 2 Episode 12 photo and presence.

It’s time for everyone to witness Fringe Season 5 Episode 7 another amazing and enticing twists and twirl from our favorite series Grimm. And I know that everyone is pretty excited for it, aren’t you one of them? And for sure, we will be indulge by another terrific and exciting adventure of the gang that will awaken our interest for another head banging story of suspense this coming Friday night.She provides your Haven Season 3 Episode 9 ex this potion in addition to suggests that it'll cleanse your ex, as just an individual 100 % pure involving cardiovascular may wake up Juliette. After using the potion, Capt. Renard kisses Juliette as well as awakens the girl upwards. Dent travels to a healthcare facility to visit the girl, but the loss of memory has already been way too state-of-the-art, and she isn't going to identify your ex. Shark Tank Season 4 Episode 10

Ideas pitched: A bobble head doll company that has an already existing presence online and wants to move into Malibu Country Season 1 Episode 3 brick and mortar side of the business (NO). A poncho created for iPhones and Blackberries that comes with a solution to tangled headphones (NO). A urologist who created an intriguing solution to bladder problems with a golf club (YES). Two gentlemen who created a technological solution for sports recruiting from high school to college (YES). Update on: Pork Barrel BBQ (from episode 106). The show includes a panel of potential investors. Two of the panel members, Robert Herjavec and Kevin O'Leary, Last Man Standing Season 2 Episode 3 have also appeared on the Canadian show, Dragons' Den. Other past and present members of the panel include: Barbara Corcoran, Daymond John, Kevin Harrington, Dallas Mavericks owner Mark Cuban, comedian Jeff Foxworthy and Lori Greiner.


Ideas pitched: a cooking device for basting (YES), house hold items made from recycled chopsticks (NO), Hunted Season 1 Episode 5 a line of books that use stress relieving techniques to calm kids to sleep (YES), a deck of flashcards to help memorize the 50 USA States (NO), and a guitar design that folds the guitar into a backpack (NO). The series is based on the Sony Pictures Television International format Dragons' Den and features a panel of entrepreneurs and business executives Pranked Season 5 Episode 11 called "Sharks" who consider offers from other entrepreneurs seeking investments for their business or product. The series is produced by Mark Burnett in conjunction with Sony and has been compared to the ABC series American Inventor.]]> mrs miki3 Delphi Fri, 16 Nov 2012 09:09:02 +0000 http://forums.mysql.com/read.php?49,571989,571989#msg-571989 RAD Studio XE3 support in dbForge Fusion for MySQL (no replies) http://forums.mysql.com/read.php?49,571989,571989#msg-571989 Looking to give only the best products to the customers and keep up with the growing development needs, Devart adds the support of the latest integrated development environment to dbForge Fusion for MySQL. Combined with the powerful functionality of dbForge Fusion, RAD Studio XE3 will take any development experience to a new level and make work even more efficient.
Download  the updated version of  dbForge Fusion for MySQL  to enjoy using the new functionality to the fullest.
We are looking forward to your comments and suggestions. Speak out to Devart Developers about the latest updated version on the  dbForge Fusion for MySQL Feedback Page.]]> Marina Nastenko Delphi Wed, 24 Oct 2012 13:42:58 +0000 http://forums.mysql.com/read.php?49,565073,565073#msg-565073 ANN: AnyDAC for Delphi v 6.0.1 - fast access to all databases ! (no replies) http://forums.mysql.com/read.php?49,565073,565073#msg-565073
DA-SOFT Technologies announces the immediate availability of major new version - "AnyDAC for Delphi" Summer 2012 v 6.0.1.
** Do not miss the chance - 25% discount on all AnyDAC orders in August ! **

Version Highlights
==================
* Support for iOS Emulator and ARM devices.
* Support for FireMonkey, including FM AnyDAC dialogs.
http://www.da-soft.com/blogs/anydac-for-delphi-and-firemonkey.html
* New Local SQL to query TDataSet's.
http://www.da-soft.com/blogs/anydac-for-delphi-and-local-sql.html
* New Centralized Cached Updates, with master-detail propagation.
http://www.da-soft.com/blogs/anydac-for-delphi-and-centralized-cached-updates.html
* New DataSnap multi-tier driver.

And more. Please, check the detailed change log at the bottom or at:
http://www.da-soft.com/anydac/anydac-for-delphi-v-6.0.1.2603-released.html

AnyDAC for Delphi
=================
AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to Firebird, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage DB, DataSnap and more. For complete list of features and availability, please check:

* AnyDAC home - http://www.da-soft.com/anydac/
* AnyDAC shop - http://www.da-soft.com/anydac/order.html
* AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features
====================
* Native access to MySQL, Firebird, SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database, DataSnap and more. Including latest DBMS versions.
* Generic access to any database supported through dbExpress or ODBC data sources.
* Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
* Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable, TADLocalSQL.
* Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
* First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
* Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
* Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X, iOS.
* Perfect integration as back-end driver for DataSnap, TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases
===================================
* Enterprise - Oracle, SQL Server, IBM DB2, Informix.
* Workgroup - MySQL, Firebird, PostgreSQL, SQL Anywhere, Interbase, Advantage DB.
* Database in clouds - SQL Azure.
* Desktop - SQLite, Access, Advantage DB, SQL CE, BlackFish SQL.
* Embedded - MySQL Embedded, SQLite, Firebird Embedded, Berkeley DB.
* Bridges - dbExpress, ODBC.
* Multi-Tier - DataSnap.

Newsletters
===========
To subscribe to the newsletter with the AnyDAC release notifications and other DA-SOFT Technologies product and company news, you can create an account at DA-SOFT web site, then go to your user profile and set "Subscribe to newsletter" to "Yes".

Follow us on:
* Twitter - http://www.twitter.com/da_soft
* Facebook - http://www.facebook.com/dasoft
* UserVoice - https://anydac.uservoice.com

--
With best regards,
DA-SOFT Technologies Team
http://www.da-soft.com]]> Dmitry Arefiev Delphi Wed, 15 Aug 2012 04:57:17 +0000 http://forums.mysql.com/read.php?49,564350,564350#msg-564350 Meet LiteDAC - SQLite Data Access Components for Delphi (no replies) http://forums.mysql.com/read.php?49,564350,564350#msg-564350 http://www.devart.com/litedac/
Key features:
-Direct access to SQLite by static linking of the SQLite library
-SQLite database encryption in Direct Mode
-User-defined functions
-Concurrent access
-64-bit Windows support
-Mac OS X and iOS support
-VCL/LCL and FireMonkey compatible
-Monitoring of per-component SQL execution
-Enhanced component and property editors
-Lazarus and Free Pascal support]]> Marina Nastenko Delphi Wed, 08 Aug 2012 07:32:12 +0000 http://forums.mysql.com/read.php?49,561889,561889#msg-561889 Query Parameter value assigned to bit field (no replies) http://forums.mysql.com/read.php?49,561889,561889#msg-561889
However, I have problem in assigning 'true/false' to the field.
eg

Query1.ParamByName('NewEmployee').Value := 1;

It did not save as true or false.

Had tried:
Query1.ParamByName('NewEmployee').AsSmallInt := 1;
Query1.ParamByName('NewEmployee').AsBoolean := True;

All did not work.]]> Man Fan Delphi Wed, 18 Jul 2012 13:30:45 +0000 http://forums.mysql.com/read.php?49,508333,508333#msg-508333 SSL connection with Zeos (no replies) http://forums.mysql.com/read.php?49,508333,508333#msg-508333
In client machine, do we need to install/store files?
eg.
ca-cert.pem
client-cert.pem
client-key.pem

If we need to store these files on local client machine, should these files be generated by DB/Netword Administrator from within MySQL server?

If local client machine do NOT need to store these files, then the Zeos connection component need to specify in its property:
'MYSQL_SSL_CA=D:/mysql/certs/ca-cert.pem'
'MYSQL_SSL_CERT=D:/mysql/certs/client-cert.pem'
'MYSQL_SSL_KEY=D:/mysql/certs/client-key.pem'
Are these paths 'D:/mysql/certs/...' the server paths?
So the local client pc needs to know the 'path' of these files on the server machine?]]> Man Fan Delphi Wed, 11 Jan 2012 01:03:36 +0000 http://forums.mysql.com/read.php?49,506833,506833#msg-506833 ANN: AnyDAC Winter 2012 (v 5.0.5) released (no replies) http://forums.mysql.com/read.php?49,506833,506833#msg-506833
DA-SOFT Technologies announces the immediate availability of
"AnyDAC for Delphi" v 5.0.5 Winter 2012.

Version Highlights
==================
- major TADTable and Live Data Window mode optimization;
- PostgreSQL v 9 support (named parameters, anonymous blocks, enums);
- Firebird v 3 support (packaged procedures, PSQL functions, identity columns, BOOLEAN data type);
- Firebird COMPUTED BY support;
- Interbase v 6, 7 support;
- Advantage v 8, 9 support;
- SQL Anywhere v 12 support;
- SQLite v 3.7.9 support;
- ElevateDB ODBC support;
- ReportBuilder DADE;
And more. For detailed change log, please, check:
http://www.da-soft.com/anydac/anydac-for-delphi-v-5.0.5.2073-released.html

AnyDAC for Delphi
==================
AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to MySQL, Oracle, PostgreSQL, Firebird, SQLite, MS SQL Server, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage Database and more. For complete list of features and availability, please check:

* AnyDAC home - http://www.da-soft.com/anydac/
* AnyDAC shop - http://www.da-soft.com/anydac/order.html
* AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features
==================
* Native access to MySQL, Oracle, PostgreSQL, Firebird, SQL Server, SQLite, DB2, InterBase, SQL Anywhere, Informix, Advantage Database and more. Including latest DBMS versions.
* Generic access to any database supported through dbExpress or ODBC data sources.
* Optimized for best possible performance. 2 times faster than dbGo, 25% faster than dbExpress.
* Reach API with 50 Delphi VCL components, including TADConnection, TADTransaction, TADQuery, TADStoredProc, TADTable, TADMemTable.
* Unified API for cross-database access, including unified data type mapping, SQL dialect abstraction, connection aliases.
* First-class support for many database-specific features, including backup, restore, validation, SQL scripting.
* Advanced Data Access Options, including Array DML, Live Data Window mode, full Unicode support.
* Delphi 5 to Delphi XE2, C++ Builder 5 to C++ Builder XE2, Lazarus / Free Pascal on Win32, Win64, Linux32, Linux64, Mac OS X.
* Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases
==================
* Workgroup - MySQL, PostgreSQL, Firebird, SQL Anywhere, Interbase, Advantage DB.
* Enterprise - Oracle, SQL Server, IBM DB2, Informix.
* Database in clouds - SQL Azure.
* Desktop - SQLite, Access, Advantage DB, BlackFish SQL, SQL CE.
* Embedded - MySQL Embedded, SQLite, Firebird Embedded, Berkeley DB.
* Bridges - dbExpress, ODBC.

Newsletters
==================
To subscribe to the newsletter with the AnyDAC release notifications and other DA-SOFT Technologies product and company news, you can create an account at DA-SOFT web site, then go to your user profile and set "Subscribe to newsletter" to "Yes".

Follow us on:
* Twitter - http://www.twitter.com/da_soft
* Facebook - http://www.facebook.com/dasoft
* UserVoice - https://anydac.uservoice.com

--
With best regards,
DA-SOFT Technologies Team]]> Dmitry Arefiev Delphi Tue, 27 Dec 2011 08:26:12 +0000 http://forums.mysql.com/read.php?49,504797,504797#msg-504797 Devart Data Access Components Now Support MAC OS X and Other OS's! (no replies) http://forums.mysql.com/read.php?49,504797,504797#msg-504797 UniDAC, ODAC, MyDAC, SDAC, PgDAC, and IBDAC support development for Mac OS X and iOS with Delphi XE2 and RAD Studio XE2. Now you can develop database applications, working with the most widely used databases, for Mac OS X and iOS. In particular, you can now work with SQLite, that is distributed with Mac OS X and iOS by the help of UniDAC. Here is the complete list of databases, that are supported on these OSes:
Oracle
MySQL
InterBase
Firebird
PostgreSQL
SQLite
Note that Update 2 for RAD Studio XE2, Delphi XE2 and C++Builder XE2 is required to use our DAC products.
New versions of our products now support Lazarus 0.9.30.2 and Free Pascal 2.4.4. We also worked hard to support new OSes with Lazarus. Now you can use our DAC products (except SDAC) to develop applications for the following OSes:
Linux x64
Mac OS X
FreeBSD

Pricing and Availability
VCL Data Access Components have flexible pricing. The Single license starts from $99.95, and you can always choose the edition that matches your needs best.
To learn more, download trial edition or order a license, please visit the Devart site: http://www.devart.com/dac.html .

About Devart
Devart is a widely recognized provider of database connectivity solutions and tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird and SQLite.
Since 1998, Devart has been focused on the development of native database data access solutions, development and database tools for a wide range of databases and development technologies. Now, Devart solutions provide the fastest data access available on the market and the broadest database support to many thousands of industry professionals.
For additional information about Devart, visit www.devart.com/company/]]> Marina Nastenko Delphi Tue, 06 Dec 2011 08:51:22 +0000 http://forums.mysql.com/read.php?49,491252,491252#msg-491252 libmysql.DLL to its maximum speed mongo DB (no replies) http://forums.mysql.com/read.php?49,491252,491252#msg-491252 a/ Is this the correct Library I should USE!!!!!!!!!!!!!!!
b/ Is SQL considering any changes to this approach.

I have started logging on to the dll:-
mysql_real_connect(PSQL, PChar(LOCAL_HOST), PChar(UserName), PChar(PassWord), PChar(DBName), 0, Nil, 0);

I have to ask the question about setting up MYSQL for a Mongo database
If I'm loading up a blog one after the next in a search process.
What is the best way to this for maximum speed without excessive memory usage?



best regards,
lex Dean]]> lex dean Delphi Fri, 28 Oct 2011 22:32:21 +0000 http://forums.mysql.com/read.php?49,490845,490845#msg-490845 Connect directly from Delphi (no replies) http://forums.mysql.com/read.php?49,490845,490845#msg-490845
Can some one show me a C++ white paper or something so no special addition is necessary to access MySQL Cluster.
I want to separate my self from the ODBC and have a raw connection

Java dose this and with Delphi i can use a object as a data container much like a mongo database. this is not only a much faster use of a data base, it also uses less memory.

thanks]]> lex dean Delphi Wed, 26 Oct 2011 23:59:41 +0000 http://forums.mysql.com/read.php?49,427143,427143#msg-427143 Connection string problems with DLL/Delphi 2006 (no replies) http://forums.mysql.com/read.php?49,427143,427143#msg-427143 I've tried changing initial catalog= to database= but it still doesn't work. I've also tried a variety of other connection strings but none appear to work.

Provider=MSDASQL.1;Password=albacore;Persist Security Info=True;User ID=root;Data Source=DanceDirector;Mode=ReadWrite;Initial Catalog=uniquefitness

The datasource DanceDirector is set up in ODBC on my machine.

Any help much appreciated - MySQL 5.1 Connector ODBC and Delphi 2006.

Regards,
Andy Tucker.]]> Andrew Tucker Delphi Sat, 16 Jul 2011 20:49:50 +0000 http://forums.mysql.com/read.php?49,425658,425658#msg-425658 ANN: AnyDAC for Delphi Summer 2011 released (no replies) http://forums.mysql.com/read.php?49,425658,425658#msg-425658
DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" Summer 2011 release v 5.0.1.1845.

Version Highlights
* New Advantage Database native ACE API driver
http://www.da-soft.com/blogs/anydac-for-delphi-advantage-database-support.html
* New TADTable with live data window mode
http://www.da-soft.com/blogs/anydac-tadtable-with-live-data-window.html
* Major refactoring of the drivers infrastructure.
* Major refactoring of the monitoring and tracing infrastructure.
* New FormatOptions.FmtDisplayXxx и FmtEditXxx options.
* New ADConnection Before/After StartTransaction, Commit, Rollback events.
* Multiple enhancements to the help system.

And more. For detailed change log, please, check http://www.da-soft.com/anydac/anydac-for-delphi-v-5.0.1.1835-released.html

AnyDAC for Delphi
AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to MySQL, Oracle, Firebird, SQLite, MS SQL Server, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix, Advantage and more. For complete list of features and availability, please check:

* AnyDAC home - http://www.da-soft.com/anydac/
* AnyDAC shop - http://www.da-soft.com/anydac/order.html
* AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features
* Native access to MySQL, Oracle, Firebird, MS SQL Server, PostgreSQL, SQLite, DB2, InterBase and more. Including latest DBMS versions.
* Optimized for best possible performance (2 times faster than dbGo, 25% faster than dbExpress).
* Generic access to any database supported through dbExpress and ODBC data sources.
* Reach API, including 50 Delphi VCL components.
* Unified API for access to cross-database features.
* First-class support for many database-specific features, including DBMS services like backup, validate.
* Unique ADO.NET-like data engine for Win32.
* Advanced Data Access Options.
* Full support for international applications, including full Unicode support in Delphi 2009 and later.
* Cross-platform support though Free Pascal (FPC).
* Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases
* Enterprise - Oracle, MS SQL Server, IBM DB2, Informix.
* Workgroup - MySQL, Firebird, PostgreSQL, SQL Anywhere, Interbase, Advantage DB.
* Database in clouds - Microsoft SQL Azure.
* Desktop - SQLite, MS Access, BlackFish SQL, MS SQL CE, Advantage DB.
* Embedded - MySQL Embedded, Berkeley DB, SQLite, Firebird Embedded.
* Bridges - dbExpress, ODBC.

Newsletters
To subscribe to the newsletter with the AnyDAC release notifications and other DA-SOFT Technologies product and company news, you can create an account at DA-SOFT web site, then go to your user profile and set "Subscribe to newsletters" to "Yes".

Follow us on:
* Twitter - http://twitter.com/#!/da_soft
* Facebook - http://www.facebook.com/#!/pages/Da-Soft-Technologies/141014252640000

--
With best regards,
DA-SOFT Technologies Team
www.da-soft.com]]> Dmitry Arefiev Delphi Tue, 05 Jul 2011 08:39:33 +0000 http://forums.mysql.com/read.php?49,425235,425235#msg-425235 Incorrect parameter datatype (no replies) http://forums.mysql.com/read.php?49,425235,425235#msg-425235
I'm using the ADO components (called dbGo in Delphi), but find SQL parameter datatype is always reported as ftString when connected to MySQL, whereas the correct datatype is reported when connected to SQL Server.

My only workaround at the moment is to manually configure each parameter to the correct datatype (very tedious).

Is there a better solution?]]> Jonathan Martin Delphi Thu, 30 Jun 2011 17:15:45 +0000 http://forums.mysql.com/read.php?49,420199,420199#msg-420199 error sintax (8 replies) http://forums.mysql.com/read.php?49,420199,420199#msg-420199
When eqsaldo=0 (zero) I receive this message on my code (Delphi 7):

tabelas.THist.Open;
tabelas.THist.Insert;
tabelas.THistsaldoqtd.Value := eqsaldo;
tabelas.Thist.Post;
tabelas.Thist.Close;

"Thist" is a table, not query (SQL). The field "saldoqtd" is type int.
When eqsaldo > 0 (zero) the post is correct.
How solve this ?
Tks]]> mauro rr Delphi Wed, 18 May 2011 23:11:15 +0000 http://forums.mysql.com/read.php?49,410179,410179#msg-410179 My Query works in WorkBench but not in Delphi 2010, Keep getting error about Syntax. (no replies) http://forums.mysql.com/read.php?49,410179,410179#msg-410179
Update hillfrpro.users
Set `Password`= AES_DECRYPT(`Password`,'****');
Update hillfrpro.users
Set `Security Question` = AES_DECRYPT(`Security Question`,'****');
Update hillfrpro.users
Set `Security Answer` = AES_DECRYPT(`Security Answer`,'****');
Select * From hillfrpro.users
Where `User Name` = :Users;
Update hillfrpro.users
Set `Password`= AES_ENCRYPT(`Password`,'****');
Update hillfrpro.users
Set `Security Question` = AES_ENCRYPT(`Security Question`,'****');
Update hillfrpro.users
Set `Security Answer` = AES_ENCRYPT(`Security Answer`,'****');

[the **** represents a word by the way!]
However when entered into Delphi i get the following error:
'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near';
Set Security Question = AES_DECRYPT(Security Question' at line 2'

if anyone can help me and tell me what im doing wrong it would be really helpful, thanks]]> Fraser Hill Delphi Wed, 02 Mar 2011 13:25:06 +0000 http://forums.mysql.com/read.php?49,405949,405949#msg-405949 Inserting to Multiple Tables (no replies) http://forums.mysql.com/read.php?49,405949,405949#msg-405949 TQuery or TClientDataSet or would it be better to use code (we use Pascal language). An array maybe? I haven't been using Delphi that long but I have inserted and updated info into one table before, not multiple. Also, these tables use pretty much the same field names.

Any help would be greatly appreciated.

Thanks in advance!!]]> Maggy Johnson Delphi Wed, 02 Feb 2011 16:04:50 +0000 http://forums.mysql.com/read.php?49,404943,404943#msg-404943 UTF8 and Delphi (no replies) http://forums.mysql.com/read.php?49,404943,404943#msg-404943 I have prepared a program using the databases MYSQL using Components MYDAC but happened to me a problem with the characters in the program shows me some data include question mark (?), but in any program of the type MYSQL Manager appear as a regular note that I have developed MyConnect the characters UTF8 Even so, this Problem appear. So please if you have to be resolved or they have gone through with one of you and resolved. please tell me.

Thank you]]> Aymen Hulwany Delphi Thu, 27 Jan 2011 13:45:26 +0000 http://forums.mysql.com/read.php?49,404539,404539#msg-404539 handle ODBC error... (no replies) http://forums.mysql.com/read.php?49,404539,404539#msg-404539
i make some database program using mysql as database and delphi XE...
the connection i used adoconnection with odbc driver...

i want to hadle if my internet connection lost when the program is running...
what event in adoconnection i should use to handle this error??

the error says "[mysql][odbc 5.1 driver][mysql 5.0.91-community-log] mysql server has gone away"

thanks...]]> maxi lionheart Delphi Tue, 25 Jan 2011 09:30:46 +0000 http://forums.mysql.com/read.php?49,402638,402638#msg-402638 Different Declarations (1 reply) http://forums.mysql.com/read.php?49,402638,402638#msg-402638
I have two different queries with similar selects, that is producing two different declaration types

The 1st query 
select
...
datediff(curdate(), date_received) as "DaysInLab"
from
...
The 2nd query 
select
...
datediff(date_closed, date_received) as "num_days"
from
...
Delphi delcares
DaysInLab as a TLargeintField
and
num_days as TIntegerField

Every so often, I get an error on the 2nd query saying that my query expects an integer field in num_days, but is receiving a Largeint. I simply delete num_days from the fields editor, add it again, and the query magically works again, only to happen again weeks later.

Any idea why the different declarations for what seems to be similar selects?]]> Alberto Lombardo Delphi Tue, 18 Jan 2011 03:43:54 +0000 http://forums.mysql.com/read.php?49,401471,401471#msg-401471 odbc not returning column names (3 replies) http://forums.mysql.com/read.php?49,401471,401471#msg-401471
I'm using Delphi 2007 and MySql ODBC v 5.01.08 from 10/28/2010. Using a TQuery object, I can do inserts and updates without problems. However, when I do a select, I don't get any columns returned. I can take my select statement and copy it into MySql Query Browser and it executes just fine returning the expected result set. I've also tried my queries with another tool that uses ODBC and the queries work fine. It must be an issue in the configuration of my TDatabase, TSession, or TQuery.

Here's my DataModules' DFM:
object dbVsFTP: TDatabase
AliasName = 'VsFTP-Steve-Dev'
DatabaseName = 'VsFTP-MySql'
LoginPrompt = False
Params.Strings = (
'USER NAME=root'
'PASSWORD=mucoolpassword')
SessionName = 'sesVsFtp'
BeforeConnect = dbVsFTPBeforeConnect
OnLogin = dbVsFTPLogin
Left = 32
Top = 24
end
object sesVsFtp: TSession
Active = True
SessionName = 'sesVsFtp'
Left = 32
Top = 72
end
object qryUser: TQuery
DatabaseName = 'VsFTP-MySql'
SessionName = 'sesVsFtp'
Left = 88
Top = 24
end

What am I missing?
TIA]]> Steve Harp Delphi Wed, 02 Feb 2011 13:42:29 +0000 http://forums.mysql.com/read.php?49,397374,397374#msg-397374 Hi, friend (no replies) http://forums.mysql.com/read.php?49,397374,397374#msg-397374 yong lorry Delphi Fri, 03 Dec 2010 11:03:25 +0000 http://forums.mysql.com/read.php?49,396181,396181#msg-396181 CHARSET=utf8 issue with delphi 7 (no replies) http://forums.mysql.com/read.php?49,396181,396181#msg-396181
sample table :

CREATE TABLE IF NOT EXISTS student
(autoid INT, fname VARCHAR (50), lname VARCHAR (50))
ENGINE=MyISAM DEFAULT CHARSET=utf8;

query : select * from student]]> aldrin mendiz Delphi Thu, 25 Nov 2010 12:36:26 +0000 http://forums.mysql.com/read.php?49,390107,390107#msg-390107 Delphi & MySQL: Database and subdatabase (no replies) http://forums.mysql.com/read.php?49,390107,390107#msg-390107
i am new to MySQL. I used to write simple applications since delphi 5 along with BDE (Visual dBase) and few of them are still running. But now BDE is obsolete and has compatibility issues with newer versions of Windows. So, i wanted to switch to real DBMS and i decided to go with MySQL.
I wrote a simple application-driver to transfer my existing data to MySQL using ADO.
Everything ok here.

But, i have a question.
My existing database architecture uses a base directory with some tables (dbf files) which are common (lets say default values, cities, professions etc), and some other directories (lets say companies) with their individual files. what would be the best approach to this architecture? I mean is there anything like subdatabase? Or i have to create a schema for the base tables and all subdatabases will be separate schemas?

Thanks in advance.]]> Vangelis Tolis Delphi Fri, 15 Oct 2010 12:29:40 +0000 http://forums.mysql.com/read.php?49,387879,387879#msg-387879 ANN: DA-SOFT AnyDAC for Delphi v 4.0.3 (no replies) http://forums.mysql.com/read.php?49,387879,387879#msg-387879
DA-SOFT Technologies announces the immediate availability of "AnyDAC for Delphi" v 4.0.3.1473.

AnyDAC for Delphi
=================
AnyDAC is an unique set of Universal Data Access Components for developing applications on Delphi, C++Builder and Free Pascal. With its powerful common architecture AnyDAC enables native high-speed direct access to MySQL, Firebird, SQLite, MS SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, MS Access, Informix and more. For complete list of features and availability, please check:

* AnyDAC home - http://www.da-soft.com/anydac/
* AnyDAC shop - http://www.da-soft.com/anydac/order.html
* AnyDAC trial - http://www.da-soft.com/anydac/download.html

AnyDAC Core Features
====================
* Native access to MySQL, Firebird, MS SQL Server, Oracle, PostgreSQL, SQLite, DB2, InterBase and more. Including latest DBMS versions.
* Optimized for best possible performance (2 times faster than dbGo, 25% faster than dbExpress).
* Generic access to any database supported through dbExpress and ODBC data sources.
* Reach API, including 50 Delphi VCL components.
* Unified API for access to cross-database features.
* First-class support for many database-specific features, including DBMS services like backup, validate.
* Unique ADO.NET-like data engine for Win32.
* Advanced Data Access Options.
* Full support for international applications, including full Unicode support in Delphi 2009 and later.
* Cross-platform support though Free Pascal (FPC) and Delphi Professional support.
* Perfect integration as back-end driver for TMS AdvGrid, RemObjects Data Abstract, Fast Report, C4D kbmMW and more.

AnyDAC Natively Supported Databases
===================================
* Enterprise - Oracle, MS SQL Server, IBM DB2.
* Workgroup - MySQL, Firebird, PostgreSQL, SQL Anywhere, Interbase, Advatage DS.
* Database in clouds - Microsoft SQL Azure.
* Desktop - SQLite, MS Access, BlackFish SQL, MS SQL CE.
* Embedded - MySQL Embedded, SQLite, Firebird Embedded.
* Bridges - DbExpress, ODBC.

--
With best regards,
DA-SOFT Technologies Team
http://www.da-soft.com]]> Dmitry Arefiev Delphi Wed, 29 Sep 2010 04:15:43 +0000 http://forums.mysql.com/read.php?49,383490,383490#msg-383490 mysql_query syntax error while sql string have length more than 256 chars (no replies) http://forums.mysql.com/read.php?49,383490,383490#msg-383490
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''bla..bla..' at line 1.


while call my function below:

function InsertSQL(strSQL: AnsiString; CS: TCriticalSection; var ErrMsg: AnsiString): boolean;
var
td: TDBCfg;
SockMySQL: PMySQL;
SQL: PChar;
begin
CS.Acquire;

Result := False;
try
{alokasi memory query}
SQL := StrAlloc(Length(strSQL)+1);

{Get database settings}
td := TDbCfg.Create;
td := GetDbConfig;

{Make MySQL Connection}
if CreateDbConn(td, SockMySQL, ErrMsg) then
begin
StrPCopy(SQL, strSQL);
if mysql_query(SockMySQL, SQL) <> 0 then
ErrMsg := 'InsertSQL->'+PCharToStr(mysql_error(SockMySQL))
else
Result := True;
end;
except on E:Exception do
ErrMsg := 'InsertSQL->'+E.Message;
end;
td.Free;
StrDispose(SQL);
mysql_close(SockMySQL);

CS.Release;
end;

The function always got this error while length of my strSQL contains more than 256 chars.
Anyone can help me to fix this function?

Thanks and best regard!]]> Andi Purwito Delphi Wed, 01 Sep 2010 02:11:57 +0000