falta libreria hbmysql

HMG en Español

Moderator: Rathinagiri

User avatar
edufloriv
Posts: 201
Joined: Thu Nov 08, 2012 3:42 am
DBs Used: DBF, MariaDB, MySQL, MSSQL, MariaDB
Location: PERU
Has thanked: 8 times
Been thanked: 13 times

falta libreria hbmysql

Post by edufloriv »

Saludos amigos,

Por fin pude construir HMG 3.5 a 64 bits y pude construir el compilador gracias a una distribución que descargue de aqui del foro.

El tema ahora es que al tratar de compilar un proyecto que tengo sobre MySql me lanza error:
D:\MySQL\InfoFarmaMySQL>C:\HMG35\BUILD64 INFOFARMA
Harbour 3.2.0dev (r1604201603)
Copyright (c) 1999-2016, http://harbour-project.org/
C:/Users/User/AppData/Local/Temp/hbmk_v4bk6e.dir/INFOFARMA.o:INFOFARMA.c:(.data+0x1a70): undefined reference to `HB_FUN_TMYSQLSERVER'
collect2.exe: error: ld returned 1 exit status
hbmk2: Error: Ejecutando enlazador. 1
gcc.exe C:/Users/User/AppData/Local/Temp/hbmk_v4bk6e.dir/INFOFARMA.o C:/Users/User/AppData/Local/Temp/hbmk_v4bk6e.dir/hbmk_n10k68.o D:/MySQL/InfoFarmaMySQL/_temp.o -pthread -static-libgcc -static-libstdc++ -static -lpthread -mwindows -Wl,--start-group -l"hmg-64" -l"crypt-64" -l"edit-64" -l"editex-64" -l"graph-64" -l"ini-64" -l"report-64" -l"hfcl-64" -lmsvfw32 -lvfw32 -l"hbvpdf-64" -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -oINFOFARMA.exe -L"C:/HMG35/harbour-64/lib/win/mingw64" -L"C:/HMG35/lib-64"

hbmk2: Sugerencia: Instala el paquete hbmysql y añade la opción 'hbmysql.hbc'
para la(s) funcion(es) que falta(n): TMySQLServer()

El mensaje es claro, esta faltando un paquete. Cuando comparo mi version 3.4 (HARBOUR\CONTRIB) con la nueva 3.5 (HARBOUR-64\CONTRIB) efectivamente no existe la carpeta hbmysql:

hbmysql.png
hbmysql.png (196.67 KiB) Viewed 2269 times

¿ Donde consigo el paquete para 64bits para esta libreria ?

De antemano muchas gracias por su tiempo.

Cordiales saludos

Eduardo Flores Rivas


LIMA - PERU

martingz
Posts: 342
Joined: Wed Nov 18, 2009 11:14 pm
Location: Mexico
Has thanked: 61 times
Been thanked: 36 times

Post by martingz »

Eduardo date una vuelta por http://whosaway.com/
tienes que pedir acceso pero te lo da rapido

saludos

User avatar
danielmaximiliano
Posts: 2508
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 624 times
Been thanked: 140 times
Contact:

Post by danielmaximiliano »

Copia la carpeta , contruye la librería de nuevo, recuerda tener instalado los fuentes de Mysql
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO

User avatar
serge_girard
Posts: 2773
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 1071 times
Been thanked: 193 times
Contact:

Post by serge_girard »

HMG 3.5 + 64 bit + MySQL: misery .... !

Serge
Serge Now Is The Happiest Time Of Your Life !

User avatar
joerg
Posts: 10
Joined: Tue Sep 25, 2012 4:08 pm
DBs Used: DBF; mySQL
Location: Austria
Been thanked: 2 times
Contact:

Post by joerg »

Hi guys :D ,

"HMG 3.5 + 64 bit + MySQL: misery .... !"
Unfortunately I have to agree with Serge.

HMG is a really good development environment and I'm loving Harbour programming language - it's much better then most programming languages I've got experience with.
As a sideline to my main job as SAP consultant and ABAP programmer I've developed an ERP and CRM system "WENE" in HMG based on a Harbour solution. This ERP system relies 100 % on mySQL and I put a lot of effort to enhance an existing object oriented mySQL interface provided by Maurilio Longo. As of today I put an effort of 4351 hours into this ERP system which is (unfortunately) only productive once. This is mostly due to the fact that I haven't got much time to push it (I'm quite busy with SAP jobs ...).

The next project is a WooCommerce WebShop integration / interfaces to WooCommerce and enhancement of WooCommerce with a generic product configuration like already programmed in HMG for WENE.
Since WooCommerce is based on mySQL (like most of the Web), with the extended mySQL interface I have a good tool to program interfaces.

With HMG I'm unfortunately stock with mySQL Server 5.6.
I tried to install mySQL Server 8.0.20 but failed to make it work with HMG because I couldn't find a 32 bit libmysql.dll library file for it - so I had to fall back on mySQL Server 5.6.
I didn't check on MySQL Community Server 8.0.23 but I fear nothing has changed.

I failed to compile WENE with HMG 3.5 both in 32 and 64 bit after spending hours trying.
Main reason: Missing mySQL and OpenSSL integration (I need OpenSSL for a digital signature thing which is a legal requirement in Austria - "Registrierkassenpflicht")

ANYHOW THERE IS NO WAY AROUND GOING 64-BIT TO HAVE A LONG TERM PERSPECTIVE!

I want to provide WENE as open source software to the world, too.
It has a generic .DBF to mySQL interface to move data once before productive start. It is a powerful, multi language (currently English and German) ERP system with tons of functionality ranging from MRP to generic product configuration, a WENE application builder to build the backbone of mySQL based applications without coding, an outbound e-mail client, a script language WENEscript to create forms, reports and labels, etc. ...
And hopefully in about a year I'll have WENE integrated with the worldwide most popular open source webshop solution WooCommerce ...

I really wish you could provide a 64-BIT only HMG release with integrated OpenSSL and mySQL libraries working with the latest MySQL Community Server 8.0.23.!

And I promise to provide WENE as open source (GNU licenced) ERP and CRM system with WooCommerce interfaces all coded in HMG ...

Thanks to all - you are doing a great job!

User avatar
serge_girard
Posts: 2773
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 1071 times
Been thanked: 193 times
Contact:

Post by serge_girard »

Joerg,

Yes it is really frustating to see "HMG 3.5 + 64 bit + MySQL: misery .... !"
I will stick to old 32bits and HMG3.4...

Serge
Serge Now Is The Happiest Time Of Your Life !

User avatar
danielmaximiliano
Posts: 2508
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 624 times
Been thanked: 140 times
Contact:

Post by danielmaximiliano »

Buen dia Muchachos
el dia de hoy baje las 2 versiones de instalador MySQL Installer 8.0.23 desde https://dev.mysql.com/downloads/windows ... r/8.0.html
Sin título-1.png
Sin título-1.png (37.67 KiB) Viewed 1368 times
en cualquiera de ellos al intentar usar cualquiera de las opciones de instalacion me dice que no estan los paquetes, supongo que si descargo el MSI de 422 megabits debe minimo tener la instalacion de Cliente con su respectivo conector
2021-03-26 08_01_16-Window.png
2021-03-26 08_01_16-Window.png (12.72 KiB) Viewed 1368 times
hago algo mal ?
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO

User avatar
Claudio Ricardo
Posts: 228
Joined: Tue Oct 27, 2020 3:38 am
DBs Used: DBF, MySQL, MariaDB
Location: Bs. As. - Argentina
Has thanked: 75 times
Been thanked: 93 times

Post by Claudio Ricardo »

Hola... Yo uso MariaDB Server, viene con Heidi y todos los .dll conectores (dentro de la carpeta del Heidi)
Para total compatibilidad con MySQL usar la versión 5.5.68 sólo 50 mb. el .msi... Cero problemas y todo free...
Corrige al sabio y lo harás más sabio, Corrige al necio y lo harás tu enemigo.
WhatsApp / Telegram: +54 911-63016162

jayadevu
Posts: 228
Joined: Tue May 19, 2009 7:10 am
Been thanked: 13 times

Post by jayadevu »

Hi,

Please look into SQLMIX Rdd, which is native to Harbour and an excellent tool to communicate with wide variety of RDMS including MYSQL,MSSQL etc. The query execution is very fast.

I am efficiently using it to communicate with MYSQL 8.0.23 (64 bits) using 32 bits program based on HMG and MiniGui Extended.

HTH,

Warm regards,

Jayadev

User avatar
Ismach
Posts: 149
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 18 times

Post by Ismach »

A tener en cuenta amigos, como Mariadb se desligo de algunas partes NO GPL que solia tener Mysql en sus inicios a partir de Mariadb version 10 dejo de incorporar algunos gestores internos de almacenamiento e indexacion y tambien dejo de incorprar libmysql.Dll y la reemplazo por LibMariadb.dll pero internamente tambien cambio de manera que no tenemos la libmariadb.a ni libmariadb.lib para HMG si usamos Mariadb 10, yo ya lo habia comentado antes.
Saludos

Post Reply