FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour FWH 17.03 : Using FWMARIADB for Embedded Server
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FWH 17.03 : MYSQL Embedded Server
Posted: Mon Mar 20, 2017 05:57 PM

You can consider MySql or MariaDB. Both work identically and our software works on both.

Regards



G. N. Rao.

Hyderabad, India
Enrico Maria Giordano
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: FWH 17.03 : MYSQL Embedded Server
Posted: Mon Mar 20, 2017 06:18 PM
TimStone wrote:We have had the discussion here many times on this forum. My belief is that we will see more capabilities for FWH as Windows continues to evolve, and they will be most easily used when building with MSVC++. Since Community 2015 / 2017 is FREE, I'm often puzzled when people revert to older technologies.


Borland compiler are not "older technologies". At least, MSVC is of 2015 while latest Borland/Embarcadero is of 2016. What is really older techology is SQL... :-)

EMG
Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg
TimStone
Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: FWH 17.03 : MYSQL Embedded Server
Posted: Mon Mar 20, 2017 06:33 PM

MSVC is actually 2017 ...

I took my application using 2017, did a "clean" in Visual Studio and rebuilt it ... and it worked.

Also, MSVC 2015 was actually updated all through 2016. They never stopped and some were major. So Visual Studio 2015 Community actually received updates through the end of 2016 and even early 2017 until the launch of 2017 a couple of weeks ago.

I've been using that version now for several years, in FULL distribution to my clients, and it works flawlessly.

Tim

Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
Enrico Maria Giordano
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: FWH 17.03 : MYSQL Embedded Server
Posted: Mon Mar 20, 2017 06:45 PM

I'm not saying anything against MSVC. I'm only saying that Borland/Embarcadero compilers are not "older technology".

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg
Sistem
Posts: 226
Joined: Sun May 13, 2012 07:52 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Wed Mar 22, 2017 02:17 PM
FWH2008 | xHarbour | BCC74 | SQLRDD
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Wed Mar 22, 2017 03:00 PM

Can not see the image

Regards



G. N. Rao.

Hyderabad, India
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Tue Aug 01, 2017 05:30 PM

You can download sample of embedded server from here

http://anserkk.com/gnraomysql/view.php?id=15

Regards



G. N. Rao.

Hyderabad, India
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Sat Aug 04, 2018 04:05 AM

Hi All,

I would like to try and test MySQL/MariaDB embedded Server ... where can I start (with Sample)?

:?:

Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Sat Aug 04, 2018 04:10 AM

fwh\samples\mysqlmbd.prg

Note: First read the program and also my first post in this thread.

Regards



G. N. Rao.

Hyderabad, India
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Sat Aug 04, 2018 07:16 AM
nageswaragunupudi wrote:fwh\samples\mysqlmbd.prg

Note: First read the program and also my first post in this thread.



Thanks Mr. Rao,

When I run the sample, I have missing file "libmysqld.dll" ... not found in FWH directory.

:-)
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Sat Aug 04, 2018 07:21 AM

You need to find and download the dll yourself. Please read the instructions in my first post of this thread.

Regards



G. N. Rao.

Hyderabad, India
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Sat Aug 04, 2018 07:52 AM
nageswaragunupudi wrote:You need to find and download the dll yourself. Please read the instructions in my first post of this thread.



Mr. Rao,

This maybe the reason I couldn't find any download ...
https://mysqlserverteam.com/mysql-8-0-retiring-support-for-libmysqld/

:-)
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
dutch
Posts: 1598
Joined: Fri Oct 07, 2005 05:56 PM
Re: FWH 17.03 : MYSQL Embedded Server
Posted: Sun Aug 05, 2018 01:59 PM
Dear Mr.Rao,

nageswaragunupudi wrote:Update:

In our tests it is possible to connect to both embedded server and also any number of main servers in the same application.
Requirements:
1) Link with libmysqld.lib instead of libmysql.lib
2) Connect to a local embedded server first before connecting to any remote server.

We welcome testing by users and feed back.


To use embedded server and remote server in the same application. I need to link libmysqld.lib and libmysqld.dll instead fo LIBMYSQL.LIB and LIBMYSQL.DLL.

Does It mean libmysqld.lib will support both embedded and remote server?

Thanks in advance.
Regards,

Dutch



FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Sun Aug 05, 2018 02:25 PM

I could use it to connect to both, view tables from both and update remote server from local tables. I did not test extensively. I do not know if it has all the functionality of the libmysql library. You may test and see.

Regards



G. N. Rao.

Hyderabad, India
dutch
Posts: 1598
Joined: Fri Oct 07, 2005 05:56 PM
Re: FWH 17.03 : Using FWMARIADB for Embedded Server
Posted: Mon Aug 06, 2018 10:50 AM

Thank you, Mr.Rao.

Regards,

Dutch



FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)
Static archive · New replies & topics via GitHub Discussions