Page 1 of 3

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Fri Jul 21, 2023 10:36 am
by goosfancito
pudiste solcionar este problema?

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Fri Jul 21, 2023 6:25 pm
by 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.

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Sat Jul 22, 2023 2:02 am
by carlos vargas
carlos vargas wrote:goos puedes contactarme por mail karlos.vargas at gmail dot com,
lo miramos por anydesk, yo tengo un modulo con en mysql embebido.

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Sat Jul 22, 2023 4:38 am
by goosfancito
Carlos! como vas? ya pude solucionarlo en breve subo un paquete funcional.

gracias.

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Sat Apr 20, 2024 6:09 pm
by FranciscoA
Goos,
Puedes darme un luz de como solucionaste el uso de mysql embebido?
Gracias.

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Sat Apr 20, 2024 6:17 pm
by FranciscoA
Fraxzi, lo solucionaste?
Puedes darme una luz?
Gracias

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Mon Apr 22, 2024 5:00 pm
by FranciscoA
Nobody?

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Tue Apr 23, 2024 9:56 pm
by nageswaragunupudi
FranciscoA wrote: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:

Re: FWH 17.03 : Using FWMARIADB for Embedded Server

Posted: Wed Apr 24, 2024 4:13 pm
by FranciscoA
Rao, muchas gracias por tu tiempo.
Mañana tendré tiempo para intentarlo.