falta libreria hbmysql

HMG en Español

Moderator: Rathinagiri

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

Re: falta libreria hbmysql

Post by danielmaximiliano »

Ismach wrote:
Fri Mar 26, 2021 8:07 pm
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
Teniendo LibMariadb.dll se puede exportar y construir LibMariadb.a
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. 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: 76 times
Been thanked: 93 times

Post by Claudio Ricardo »

Hola...
Con MariaDB viene HeidiSQL (si lo queremos instalar) y en él están esas librerías.
Screenshot_20210326_185607.png
Screenshot_20210326_185607.png (95.56 KiB) Viewed 1016 times
También en las carpetas de MariaDB hay muchas más.
Con sólo poner libmysql.dll (es la que pide la función de Harbour)
en la carpeta junto a los archivos del programa me funciona perfecto
tanto con bases MySQL como MariaDB (hasta la v. 5.5.68 es 100% compatible)

Si necesitan los conectores para C, C++ y otros lenguajes:
https://downloads.mariadb.org/connector-c/+releases/
Corrige al sabio y lo harás más sabio, Corrige al necio y lo harás tu enemigo.
WhatsApp / Telegram: +54 911-63016162

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 »

Claudio,

HeidiSQL + Maria + HMG35 + WINDOWS10 is really working?

What stpes do I have to taken in order to get it all working?

Thx, Serge
Serge Now Is The Happiest Time Of Your Life !

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: 76 times
Been thanked: 93 times

Post by Claudio Ricardo »

Hi Serge ...
I use MariaDB 5.5.68 version for 64-bit Windows. and HMG 3.4.4 32 bits. Latest version of HeidiSQL for 64 bits.
Operating system guess W7 Home Premium SP1 x64 as virtual machine in VirtualBox with 3gb. Ram, two core and LAN in bridge mode.
Operating system host (at the moment) is KDE Neon 5.19 64-bit. with 12 gb. ram, quadcore 3.9ghz.
And it works perfectly ...
I use that version of MariaDB because I don't need the features of the newer versions and because it is 100% compatible with MySQL.
In a commercial remote host with CentOS 7 and MariaDB the latest version a year and a half ago, a client with two programs that I made with HMG 3.4.4 accesses it from four branches of his shops without problems.
HeidiSQL is similar to Navicat but more comfortable to use as well as free.
I haven't tried HMG 3.5 yet due to lack of time.
MariaDB works perfectly in W10 (a friend has it like this)
On Youtube there are many videos about the installation.

You just need to put libmysql.dll in the folder of the program you are making and add a fourth parameter (port) to the Harbor function so that it looks like this:
oServer: = TMySQLServer (): New (cHostName, cUserName, cPassWord, nHostPort)
and assign the port number to that variable, in this case 3306 but you can use another one, without it (to me), I did not connect with the hosting.
In the MariaDB .msi include Heidi but is better not install this version and download the latest from official page.
Download MariaDB all version: https://mariadb.org/download/
Download HeidiSQL: https://www.heidisql.com/
Corrige al sabio y lo harás más sabio, Corrige al necio y lo harás tu enemigo.
WhatsApp / Telegram: +54 911-63016162

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 »

Estimados
con mysql y mariadb 5.x funciona eso nadie los discute...

a ver mejor los desafio

Intenten compilar ejecutar y acceder a Mariadb 10(64 bits) y superiores compilando con esa libreria libmysql.dll y libmysql.a y diganme que funciona.

Yo no hablo de mysql, hablo de Mariadb 10 y superiores... que a mi modo de ver y despues trabajar mucho con esta base de datos me parece mucho pero mucho mejor que mysql de oracle.

Saludos

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: 76 times
Been thanked: 93 times

Post by Claudio Ricardo »

Hola Ismach...
Si lo tienes en un hosting, crea una DB como la de la foto y pasame los datos:
IP o dominio, puerto, usuario, password y nombre de la DB
que intento conectar y cargar un par de datos en ella desde un programa
que estoy desarrollando.
Screenshot_20210327_171216.png
Screenshot_20210327_171216.png (17.04 KiB) Viewed 972 times
Corrige al sabio y lo harás más sabio, Corrige al necio y lo harás tu enemigo.
WhatsApp / Telegram: +54 911-63016162

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 »

No no tengo, el unico que tengo esta en mysql 5.1.

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 »

Claudio,

Maybe I was not very clear... My database is hosted and they use MariaDB 10.4
This is fine and no problem to me when I use HMG344 (32b) and W10. HMG344 (64b) and HMG35 and won't work with libmysql.dll.

Serge
Serge Now Is The Happiest Time Of Your Life !

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: 76 times
Been thanked: 93 times

Post by Claudio Ricardo »

Hi Serge ... excuse me please.
I use 32-bit HMG 3.4.4 because even today there are those who use 32-bit W7, W8, W10,
it is to avoid compatibility problems with clients that have older computers.
HMG 3.5 I have not tried it yet because I read in the forum that some things did not work quite well,
but when I have a free weekend (something difficult because I have a lot of work) I download it,
and I will tell here if it worked well for me.
Corrige al sabio y lo harás más sabio, Corrige al necio y lo harás tu enemigo.
WhatsApp / Telegram: +54 911-63016162

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 »

Thanks Claudio, it is not a matter of life and death..! I continue with HMG344 + W10 32b for the time being.

Serge
Serge Now Is The Happiest Time Of Your Life !

Post Reply