UNIDAC Connecting embedded MySQL server

Source: Internet
Author: User

Simple question about MySQL embedded application. Post a Reply7 posts page 1Of 1Simple question about MySQL embedded application.

by Tanghz »mon Oct 2010 23:29

Hi
I am wondering how I can use the embedded MySQL server in a Delphi application via UNIDAC? Does you have a demo for this? Better give me a step by step guide if possible.
Thanks very much.
Tanghz
Posts:
Joined: Wed, Jan 02:40
Top

by Andreyz »tue Oct 2010 08:05

Hello,

You can look at the mydacdemo->technologyspecific->embedded demo. This demo demonstrates working with Embedded MySQL Server. If you don't have MYDAC you can download Mydac Trial version. Also you can read the Using Embedded Server topic in Mydac Reference Manual.
Andreyz
Devart Team
Posts: 2506
Joined: Fri Sep 07:16
Top

by Tanghz »tue Oct 2010 16:26

Hi, I purchased UNIDAC. Would you include that embedded part of the function in this product? This was a standard feature of MySQL, I presume.
Tanghz
Posts:
Joined: Wed, Jan 02:40
Top

by Andreyz »wed Oct 2010 08:10

Unidacdemo doesn ' t has the example of working with Embedded MySQL Server. That's why your can look on this example only in Mydacdemo.

You can connect to the Embedded MySQL server with UNIDAC in the following:
Code:select All
  UniConnection.ProviderName := ‘MySQL‘; 
  UniConnection.Database := DatabaseName; 
  UniConnection.SpecificOptions.Values[‘Embedded‘] := ‘True‘; 
  UniConnection.SpecificOptions.Values[‘EmbeddedParams‘] := ‘--basedir=.‘#13#10‘--datadir=data‘;

The--basedir parameter sets the base path for the Embedded MySQL server. All paths is usually used relatively to the base path. The--datadir parameter sets the path to the data directory. Last edited by Andreyz at Wed Oct 11:07, edited 1 time in total.
Andreyz
Devart Team
Posts: 2506
Joined: Fri Sep 07:16
Top

by Tanghz »wed Oct 2010 10:11

Great, this was a special offer.
I'll try it and feed back to you.
Very well thought, unidac!
Tanghz
Posts:
Joined: Wed, Jan 02:40
Top Re:simple question about MySQL embedded application.

by Vallemanden »wed SEP 2012 11:49

I tryed this but I keep getting error on can ' t load libmysql.dll, but it's in the same dir where the exe fil is

Using Firemonkey
MySQL 5.5
UNIDAC 4.5.9

"MySQL client library couldn ' t be loaded. Libmysqld.dll file to System folder, included to PATH, or to the folder with executable unit of main program. "
Vallemanden
Posts:
Joined: Sat One June 07:44
Top Re:simple question about MySQL embedded application.

by Andreyz »wed SEP 2012 14:28

Sure placed the Libmysqld.dll (and not libmysql.dll) library to the directory where the executable file of Your application is located. Also, please note this should use 32-bit Libmysqld.dll for 32-bit applications, and 64-bit Libmysqld.dll for 64-bit AP Plications.

Http://www.cnblogs.com/wxb-km/archive/2012/11/21/2781719.html

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.