I expected a "Database Name" property in the TADTable but I could not find it, did I miss it somewhere? All rights reserved. Developer Tools Blackfish SQL C++Builder Delphi FireMonkey Prism InterBase JBuilder J Optimizer HTML5 Builder 3rdRail & TurboRuby Database Tools Change Manager DBArtisan DB Optimizer ER/Studio Performance Center Normally, plugins are located in
Get 1:1 Help Now Advertise Here Enjoyed your answer? I did find notes about giveing write permissions to the configuration files (.ini file) so I did that for the entire C:\Program Files\Embarcadero\FireDAC directory. Also tried pointing Vendorlib in delphi to C:\Program Files\MySQL\MySQL Server 5.6\lib\libmysql.dll. At the end, VendorLib is set to nothing with the 32-bit dll in the project folder and the 64-bit dll in the debug folder and everything works fine for me.
Sitemap / Contact / Home MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines But when I try to connect, there is an error "cannot load vendor library libmysql.dll or libmysqld.dll" I read embaradeco manual and I have been tried 1. Hint: Check it is in the PATH or application EXE directories, and has x86 bitness. FireDAC does not have any special requirements to the DBMS client software.
In my application I access a dDataBase's table using the usual components: TSQLConnection, TSQLDataSet, TDataSetProvider, TClientDataSet, TDataSource y TDBGrid. Should the FireDAC installer have loaded it if it is required? Other Usage Cases Connect to a locally running server, listening on the default (3306) port: DriverID=MySQL Database=addemo User_Name=root Password= Connect to a remote server, listening on a non-default port, using Unicode have a peek here Upscene Productions www.upscene.com Ross Davis Delphi Developer 2004-01-21 04:06:12 PM Re:DbExpress and MySQL The crlab.com driver works for the most part.
Dmitry Arefiev Posts: 1,164 Registered: 12/7/03 Re: FireDAC Install for Mere Mortals Reply Posted: Dec 13, 2013 11:32 PM in response to: Greg Cromack If you know the The libmysql.dll that I am trying to get FireDAC to use is being copied from the Program Files directory to various other directories so I am assuming that it is the I also tried to put the libmysql.dll (64bit v5.6.15) to all those three folders, but still encounter the same error. I've never worked with Delphi-MySQL (I've done a Delphi-Interbase program, but it was on the same machine) Should I use DBExpress for this, or it is there a better way ?
mysql database delphi firedac share|improve this question edited Feb 18 '14 at 15:21 Sir Rufo 10.8k21946 asked Feb 18 '14 at 14:46 aurallion 2914 2 The IDE is 32bit and http://docwiki.embarcadero.com/RADStudio/Seattle/en/Connect_to_MySQL_Server_(FireDAC) Bob K. Firedac Phys Mysql Bob K. Libmysql.dll Download THe system cannot find the file spcified.
UseSSL Specify True to enable SSL connection. this contact form Edited by: Greg Cromack on Dec 27, 2013 9:13 PM TSQLConnection is DBX not FireDAC. Thanks share|improve this answer answered Feb 16 at 9:23 aurallion 2914 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Dave Nottage Posts: 846 Registered: 1/7/00 Re: FireDAC Install for Mere Mortals Reply Posted: Aug 7, 2013 8:02 PM in response to: Robert Kondner Robert Kondner wrote: 1.
Then please post your 2 environment reports: http://docwiki.embarcadero.com/RADStudio/XE5/en/DBMS_Environment_Reports_(FireDAC) 1) with TFDPhysMySQLDriverLink.VendorLib specified; 2) and without. -- With best regards, Dmitry Arefiev / FireDAC Architect FireDAC - Firebird, SQLite, MySQL, SQL Server, it's works well done, I try to download then i copy that to my system32 folder, and i try to connect to mysql database but still the same problem, after that Hope it helps! have a peek here If your application does not connect to a remote MySQL server, add the --skip-networking argument.
Ballpark salary equivalent today of "healthcare benefits" in the US? Pen Tester's Programming Style Select 2D data in a certain range If I receive written permission to use content from a paper without citing, is it plagiarism? I was surprised that the "DataBase Name" could only be defined in the TADConnection.LiveBindings.Params string list.
I think FireDAC is a great product but it has not been easy. Dmitry Arefiev replied on 24-Jun-2009: Hello Vasileios Try to search for libmysql.dll dublicates on your PC. This incident will be reported 40 Vertices And A Connected Graph, Minimum Number Of Edges? Driver Linkage To link the driver: drop a TFDPhysMySQLDriverLink component from the "FireDAC Links" component palette page or include the FireDAC.Phys.MySQL unit in the uses clause.
Data Explorer is dbExpress tool. -- With best regards, Dmitry Arefiev / FireDAC Architect FireDAC - Firebird, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Access, Informix, ODBC high-speed data I was having the same problem. The error Cannot load vendor library [libmysql.dll or libmysql.dll is quite clear. Check This Out Dumb Question: This is FireDAC_22.214.171.12465 I loaded, are there suppose to be these issues or should I head back to MyDAC from Devart?
The libmysql.dll that I am trying to get FireDAC to use is being copied from the Program Files directory to various other directories so I am assuming that it is the Does anyone know how to find it? You can take them from a server (details) installation Bin or Lib folders and place them in: a folder listed in your PATH environment variable (for example,
Program to check whether two strings are anagrams of each other Can Egyptian citizen visit Armenia on valid USA visa? I searched and "destroyed" all versions of libmysql.dll resident on my PC. copy libMySQL.dll to my “c:\program files (x86)\Embarcadero\Studio\\bin” : fail(That means cannot load db data, still got error) 2. Uve (Denmark) Jan 24, 2012 Thank you very much.
Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re… Delphi How to Send a Secure eFax Video by: j2 Global Sending a Asking questions, pleading answers from the nameless faceless watchers that stalk the carpeted corridors of Whitehall. (Fish) Greg Cromack Posts: 8 Registered: 5/1/09 Re: FireDAC Install for Mere Mortals Reply cp1251 Compress Specify True to enable network traffic compression. One TADConnection instance for each database, right?
Check the version of that dll. Manually configure directory permissions so FireDAC can write to its .INI file. Best regards. 9. I do hope this is added to the somewhat lacking documentation of embracedero XE2 16.
There will be another video to explain how to put the final p… MS Office Office 365 MS Access Advertise Here 771 members asked questions and received personalized solutions in the George Christoforakis Delphi Developer 2004-01-19 09:56:49 PM Re:DbExpress and MySQL DBExpress doesn't support mysql 4.1.x well.