Page 1 of 1
MariaDB
Posted: Wed Jun 23, 2021 3:04 pm
by jorge.posadas
Grupo
¿Alguien sabe CÓMO saber qué versión de MariaDB tengo instalado ? y que esa lo pueda leer desde mi aplicación
De antemano gracias por la ayuda.
Re: MariaDB
Posted: Wed Jun 23, 2021 4:05 pm
by dragancesu
Newer versions in the installation have HeidiSQL, a great database management program, there you will see which version of the database you are connected to
if not, search and download, it's free
Re: MariaDB
Posted: Wed Jun 23, 2021 4:07 pm
by dragancesu
Re: MariaDB
Posted: Wed Jun 23, 2021 7:00 pm
by jorge.posadas
Grupo
Gracias ya supe como ver la versión de MariaBD que tengo instalada
Re: MariaDB
Posted: Fri Jun 25, 2021 3:54 am
by Ismach
ir al directorio donde tenes instalado en modo console y ejecutar el comando:
mysql --version
Code: Select all
Microsoft Windows [Versión 10.0.19042.1052]
(c) Microsoft Corporation. Todos los derechos reservados.
C:\Mariadb10\bin>
C:\Mariadb10\bin>mysql --version
mysql Ver 15.1 Distrib 10.5.9-MariaDB, for Win64 (AMD64), source revision 3a8ca9096ea82ca61811450775511533d6cb1bb4
C:\Mariadb10\bin>
Re: MariaDB
Posted: Thu Jul 01, 2021 4:52 pm
by jorge.posadas
Gracias Ismach,
Re: MariaDB
Posted: Sat Jul 03, 2021 8:09 am
by Claudio Ricardo
Hola...
Cuando envio el query "SELECT VERSION();" la funcion que utilizo espera recibir un array pero como en este caso es un string lo considera error y me devuelve Nil...
Como hago para recibir ese string o el resultado de cualquier otra funcion de SQL (en este caso MariaDB) ?
Desde ya muchas gracias !
Translate Google:
Hi...
When I send the query "SELECT VERSION ();" The function I use expects to receive an array but as in this case it is a string, it considers it an error and returns Nil ...
How do I get that string or the result of any other SQL function (in this case MariaDB)?
Thanks in advance !
Re: MariaDB
Posted: Sat Jul 03, 2021 9:30 am
by Rathinagiri
Can I know which library you are using to connect to Maria DB from HMG?
If you use HMGMYSQL Library, the following code is perfectly running for me.
Code: Select all
aTable := sql( oDB, 'SELECT VERSION ()')
if hmg_len( aTable ) > 0
msginfo( aTable[ 1, 1 ] )
endif
Re: MariaDB
Posted: Sat Jul 03, 2021 8:47 pm
by Claudio Ricardo
Hi Rathinagiri... I use libmysql.dll with one lib similar to HFCL SQL i copy from Daniel Crocciari (Many Thanks to him)
i have the same code, but my error is that it did not decode the db password, encoded a few lines above, so it returned empty
i move the encode a few lines below, and work fine now ! Thank you Mr. Dyamond for your fast answer !!!