Home How to embed MySQL (libmysqld.dll) using Delphi ZEOS
Reply: 0

How to embed MySQL (libmysqld.dll) using Delphi ZEOS

user43680
1#
user43680 Published in September 21, 2018, 8:15 am

I'm trying to use embedded mysql database using libmysqld.dll (mysql 5.1) with zeos (7.0.3) in Delphi XE
i put libmysqld.dll in the same directory,
folder language\errmsg.sys
folder data\belajar\biodata.frm,biodata.MYD,biodata.MYI,db.opt

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ZAbstractConnection, ZConnection;

type
  TForm1 = class(TForm)
    Button1: TButton;
    ZCon: TZConnection;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
       ZCon.Protocol := 'mysqld-5';
       zcon.Database := 'belajar';
       zcon.Connect;
end;

end.

When i run the code, click the button1 and then it just closed, no error message, the application terminated.

any help?


update:

i have solved this problem, i put the wrong name and version of "language" folder, it should be "share" folder and errmsg.sys in the english subfolder

thankyou everyone

share|improve this question
  • 1
    1) Trace incide into zcon.Connect to see exact error point. / 2) Sysinternals Process Monitor can help you to see last program action before crash, that sometimes solves "wrong path" issues / 3) use more traditional for embedding database, like SQLite, Firebird, NexusDB, etc – Arioch 'The May 8 '13 at 16:04
  • 1
    Try to set all of the connection's properties via the object inspector, and set the connected property to true. See what error message you get. Also, make sure that you don't mix a 32bits application with a 64bits libmysqld. – Wouter van Nifterick May 8 '13 at 17:32

active oldest votes

Your Answer

StackExchange.ifUsing("editor", function () { StackExchange.using("externalEditor", function () { StackExchange.using("snippets", function () { StackExchange.snippets.init(); }); }); }, "code-snippets"); StackExchange.ready(function() { var channelOptions = { tags: "".split(" "), id: "1" }; initTagRenderer("".split(" "), "".split(" "), channelOptions); StackExchange.using("externalEditor", function() { // Have to fire editor after snippets, if snippets enabled if (StackExchange.settings.snippets.snippetsEnabled) { StackExchange.using("snippets", function() { createEditor(); }); } else { createEditor(); } }); function createEditor() { StackExchange.prepareEditor({ heartbeatType: 'answer', convertImagesToLinks: true, noModals: false, showLowRepImageUploadWarning: true, reputationToPostImages: 10, bindNavPrevention: true, postfix: "", onDemand: true, discardSelector: ".discard-answer" ,immediatelyShowMarkdownHelp:true }); } });
 
StackExchange.ready( function () { StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f16445003%2fhow-to-embed-mysql-libmysqld-dll-using-delphi-zeos%23new-answer', 'question_page'); } );

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged mysql delphi zeos or ask your own question.

StackExchange.ready(function(){$.get('/posts/16445003/ivc/aa73');});
StackExchange.ready(function () { StackExchange.responsiveness.addSwitcher(); }) (function(i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function() { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m); })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); StackExchange.ready(function () { StackExchange.ga.init({ sendTitles: true, tracker: window.ga, trackingCodes: [ 'UA-108242619-1' ] }); StackExchange.ga.setDimension('dimension2', '|mysql|delphi|zeos|'); StackExchange.ga.setDimension('dimension3', 'Questions/Show'); StackExchange.ga.trackPageView(); }); /**/ var _qevents = _qevents || [], _comscore = _comscore || []; (function() { var ssl = 'https:' == document.location.protocol, s = document.getElementsByTagName('script')[0], qc = document.createElement('script'); qc.async = true; qc.src = (ssl ? 'https://secure' : 'http://edge') + '.quantserve.com/quant.js'; s.parentNode.insertBefore(qc, s); _qevents.push({ qacct: "p-c1rF4kxgLUzNc" }); /**/ var sc = document.createElement('script'); sc.async = true; sc.src = (ssl ? 'https://sb' : 'http://b') + '.scorecardresearch.com/beacon.js'; s.parentNode.insertBefore(sc, s); _comscore.push({ c1: "2", c2: "17440561" }); })();
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.360122 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO