FWH 17.03 : Using FWMARIADB for Embedded Server

[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

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

\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

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