FWH 17.03 : Using FWMARIADB for Embedded Server

User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: FWH 17.03 : MYSQL Embedded Server

Post by nageswaragunupudi »

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

G. N. Rao.
Hyderabad, India
User avatar
Enrico Maria Giordano
Posts: 7355
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Contact:

Re: FWH 17.03 : MYSQL Embedded Server

Post by Enrico Maria Giordano »

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
User avatar
TimStone
Posts: 2536
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA
Contact:

Re: FWH 17.03 : MYSQL Embedded Server

Post by TimStone »

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
timstone@masterlinksoftware.com
Using: FWH 19.06 with Harbour 3.2.0 / Microsoft Visual Studio Community 2019
User avatar
Enrico Maria Giordano
Posts: 7355
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia
Contact:

Re: FWH 17.03 : MYSQL Embedded Server

Post by Enrico Maria Giordano »

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

EMG
User avatar
Sistem
Posts: 224
Joined: Sun May 13, 2012 7:52 am

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by Sistem »

Image
FWH2008 | xHarbour | BCC74 | SQLRDD
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by nageswaragunupudi »

Can not see the image
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by nageswaragunupudi »

You can download sample of embedded server from here

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

G. N. Rao.
Hyderabad, India
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by fraxzi »

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
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by nageswaragunupudi »

fwh\samples\mysqlmbd.prg

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

G. N. Rao.
Hyderabad, India
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by fraxzi »

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.

:wink:
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
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by nageswaragunupudi »

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
User avatar
fraxzi
Posts: 811
Joined: Tue May 06, 2008 4:28 am
Location: Philippines
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by fraxzi »

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-r ... libmysqld/

:cry:
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
User avatar
dutch
Posts: 1395
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: FWH 17.03 : MYSQL Embedded Server

Post by dutch »

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 19.01 / 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)
User avatar
nageswaragunupudi
Posts: 8017
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Contact:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by nageswaragunupudi »

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
User avatar
dutch
Posts: 1395
Joined: Fri Oct 07, 2005 5:56 pm
Location: Thailand

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Post by dutch »

Thank you, Mr.Rao.
Regards,
Dutch

FWH 19.01 / 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)
Post Reply