FWH 17.03 : Using FWMARIADB for Embedded Server

[nageswaragunupudi]

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

[Enrico Maria Giordano]

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

[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

[Enrico Maria Giordano]

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

EMG

[Sistem]

[nageswaragunupudi]

Can not see the image

[nageswaragunupudi]

You can download sample of embedded server from here

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

[fraxzi]

Hi All,

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

[nageswaragunupudi]

fwh\samples\mysqlmbd.prg

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

[fraxzi]

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.

[nageswaragunupudi]

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

[fraxzi]

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/

[dutch]

Dear Mr.Rao,

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.

[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.

[dutch]

Thank you, Mr.Rao.