FWH 17.03 : Using FWMARIADB for Embedded Server

[fraxzi]

Hi All,

I successfully run sample 'mysqlmbd.prg', it created data on a folder I specify..
but on the line...

Code: Select all  Expand view  RUN

   REQUEST DBFCDX
   ...
   oCn:importfromdbf( "customer.dbf" )   // <<= it quits here
   ...
 

It quits with no logs or nothing to trace...

[MarioG]

[quote="nageswaragunupudi"]It is now possible to use FWMariaDB to create and use MYSQL embedded server from version FWH 17.03, using libmysqld.dll instead of libmariadb.dll (or libmysql.dll). This Possible only with 32 bit Borland and MSVC Harbour / xHarbour. Not possible with 64 bit compliers.

Usage:

1) Download libmysqld.dll
2) Build implib libmysqld.lib for borland or msvc compiler as required.
3) Link the application with this implib instead of libmariadb.dll (or libmysql.lib)
4) Locate or create a folder containing "errmsg.sys" file for the language required. (cLangFolder)
5) Creae a folder for creation of the embedded server.(cDataFolder)
6) Use the same command for connection, specifying cDatFolder (with trailing backslash) as HOST and cLangFolder as LANGFOLDER. Important: cDataFolder should contain trailing backslash.

Hello;
I download de last version of Mariadb Server, 10.5.3
When I launch:
D:\Bat>implib libmariadb.lib libmariadb.dll
Return that error:
Embarcadero Implib Version 3.3.0 Copyright (c) 1991-2014 Embarcadero Technologies, Inc.
Error libmariadb.dll: unknown file type

My BCC is: Embarcadero C++ 7.00 for Win32 Copyright (c) 1993-2015 Embarcadero Technologies, Inc. and;
my implib is: Embarcadero Implib Version 3.3.0 Copyright (c) 1991-2014 Embarcadero Technologies, Inc.

[nageswaragunupudi]

You posted this under the topic Embedded server.

For using embedded server,

1. You do not have to install MySql server or MariaLib server
2. What all you need is "libmysqld.dll"
3. We do not get this dll along with either Mysql server / MariaLib server installations. We need to download it separately.

In case you are not talking about Ebedded server, but normal Mariadb server,

D:\Bat>implib libmariadb.lib libmariadb.dll
Return that error:
Embarcadero Implib Version 3.3.0 Copyright (c) 1991-2014 Embarcadero Technologies, Inc.
Error libmariadb.dll: unknown file type

It is likely that the dll is 64-bit, not 32-bit.

Instead you may use the dll and lib that come with fwh
\fwh\dll\libmariadb.dll
\fwh\lib\libmariadb.lib

[MarioG]

Mr Rao
many thanks

[Marcelo Roggeri]

Hola buenas noches siguiendo el hilo, quiero reportar que yo tengo el mismo problema.

implib libmariadb.lib libmariadb.dll

Embarcadero Implib Version 3.3.0 Copyright (c) 1991-2014 Embarcadero Technologies, Inc.
Error : unable to open file

Que debería hacer? para poder utilizar mysql embebido?

Saludos

[goosfancito]

pudiste solcionar este problema?

[carlos vargas]

goos puedes contactarme por mail karlos.vargas at gmail dot com, o al 505 8767 4989 por what
lo miramos por anydesk, yo tengo un modulo con en mysql embebido.

[carlos vargas]

goos puedes contactarme por mail karlos.vargas at gmail dot com,
lo miramos por anydesk, yo tengo un modulo con en mysql embebido.

[goosfancito]

Carlos! como vas? ya pude solucionarlo en breve subo un paquete funcional.

gracias.

[FranciscoA]

Goos,
Puedes darme un luz de como solucionaste el uso de mysql embebido?
Gracias.

[FranciscoA]

Fraxzi, lo solucionaste?
Puedes darme una luz?
Gracias

[FranciscoA]

Nobody?

[nageswaragunupudi]

Nobody?

This is how you can use Embedded Server using FWH library.

We need 3 files for this:
1. libmysqld.dll:
Required to be kept in exe folder. We already have this in \fwh\samples folder.
2. libmysqld.lib:
Imblib for this dll. Required for linking. We should use this but not libmyql.lib
We already have this in our \fwh\lib\ folder
3. errmsg.sys:
language specific err messages. Required to be kept in some folder.
This file is not readily available in FWH folders. If you installed dolhpin, you may file it in dolphin folders or in some mysql installation folders. If you do not find it on your disk, ..
Please download this file "errmsg.fwh" from the link:
https://github.com/FiveTechSoft/FWH_too ... errmsg.fwh
Copy the downloaded file to fwh\samples\ folder and then rename it as "errmsg.sys". (This is important)

Now, make this small modification to buildh.bat
Open "notepad.exe buildh.bat" and locate the line

Code: Select all  Expand view  RUN

echo %fwh%\lib\FiveH.lib %fwh%\lib\FiveHC.lib %fwh%\lib\libmysql.lib + >> b32.bc

Change "libmysql.lib" as "libmysqld.lib" and save.

Now we are ready.
As a final check, make sure we have these 3 files in these folders:

Code: Select all  Expand view  RUN

\fwh\lib\libmysqld.lib
\fwh\samples\libmysqld.dll
\fwh\samples\errmsg.sys

We need to choose some folder to hold our database on our disk.
Suppose we choose "C:\MYDATA\"
Then try this program:

Code: Select all  Expand view  RUN

#include "fivewin.ch"

REQUEST DBFCDX

function Main()

   local oCn

   FWCONNECT oCn HOST "C:\MYDATA\"     ;  // "Your Data folder
           LANGFOLDER TrueName( ".\" ) ;  // "folder where errmsg.sys file is located
             DATABASE "fwh"

   if ocn == nil
      ? "Connect fail"
   else
      ocn:importfromdbf( "customer.dbf" )
      ocn:importfromdbf( "states.dbf" )
      xbrowser ocn:customer NOMODAL
      xbrowser ocn:states
      ocn:close()
   endif

return nil

Save this sample prg to fwh\samples folder and build it with the modified buildh.bat
Done:

[FranciscoA]

Rao, muchas gracias por tu tiempo.
Mañana tendré tiempo para intentarlo.