Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB Tools

Lost Password?

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 02-25-2015, 04:50 AM
lexd lexd is offline
Senior Member
 
Join Date: Feb 2015
Posts: 268
Default Zeos mySQL linking

I have installed Zeos, and MySQL Installer 5.5.42, windows 7, Delphi 7

I found libmysql.dll under folder C:\Program Files\MySQL\MySQL Server 5.6\lib ok

I placed C:\Program Files\MySQL\MySQL Server 5.6\lib in my Delphi\tools\environment Options\Library\Library path and browsing path.

But cannot get :- Zeos, SQL Connection1 to find the libmysql.dll.
everything is freshly installed

Opening SQL Connection1
driver name: MySQL
HostName: Server Name
Database name: DBNAME
User_Name and Password I have set at both in MySQL and SQL connection to 'root'.
BlobSize : -1 I want to use pictures should this be larger for pictures like 16 megs
MySQL otherwise is default in all its settings.
I have kept the install record but its too big to upload and the database is working though local host.

Any idea's please.

Last edited by lexd; 02-25-2015 at 04:53 AM.
  #2  
Old 02-25-2015, 11:49 AM
kolbasz kolbasz is offline
Senior Member
 
Join Date: Nov 2013
Posts: 841
Default

Copy the libmysql.dll to your project folder. It should be a LibraryLocation property(TZconnection), enter the full path to your dll. On form create, you should also give the full path programatically, in case you move your exe/dll, to another folder.

Code:
ZConnection1.LibraryLocation := ExtractFilePath(Application.Exename) + 'libmysql.dll';
Where ZConnection1 is your main TZConnection.

Hope this helps!
  #3  
Old 02-25-2015, 12:04 PM
lexd lexd is offline
Senior Member
 
Join Date: Feb 2015
Posts: 268
Angry

I found that dose not work at all.
I found: - make a windows shortcut with both *.dll's and place it in with my project. That worked perfectly.

The thing is my end product is not going to like doing that. I need Zeos to look past my end product's (*.EXE) current folder.

And now it asks me for db2cli.dll and that's not apart of MySQL as far as I can figure out (at all). Everything talks about it as a MS SQL product to link to the ADO or OBDC or something like this. I must ask what *.dll's go with it as well. so I'm looking for a download from something.
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:09 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.