FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour FWCONNECT con MysqL (SOLUCIONADO)
Posts: 1078
Joined: Thu Sep 27, 2007 03:47 PM

FWCONNECT con MysqL (SOLUCIONADO)

Posted: Tue Dec 03, 2019 08:40 PM

Saludos
FWCONNECT
Alquien a trabajado Mysql , o solamente funciona con Mysql 5.5

Ruben Dario Gonzalez
Cali-Colombia
rubendariogd@hotmail.com - rubendariogd@gmail.com
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: FWCONNECT con Mysql 8.017

Posted: Wed Dec 04, 2019 12:04 PM

Connects to 8.0 also

Regards



G. N. Rao.

Hyderabad, India
Posts: 1078
Joined: Thu Sep 27, 2007 03:47 PM

Re: FWCONNECT con Mysql 8.017

Posted: Wed Dec 04, 2019 12:30 PM

Saludos
Regards
Hola La version de Mysql que tienes Instalada es de 32bits o 64bits.

Ruben Dario Gonzalez
Cali-Colombia
rubendariogd@hotmail.com - rubendariogd@gmail.com
Posts: 817
Joined: Sun Jun 15, 2008 07:47 PM

Re: FWCONNECT con Mysql 8.017

Posted: Wed Dec 04, 2019 02:58 PM

HDO también funciona en 32 y 64, además funciona con SQLite, Access, MS Server, DB2 etc, etc :D

______________________________________________________________________________

Sevilla - Andalucía
Posts: 817
Joined: Sun Jun 15, 2008 07:47 PM

Re: FWCONNECT con Mysql 8.017

Posted: Wed Dec 04, 2019 02:59 PM

Se me olvidaba, También tiene un RDD que funciona con todas esa bases de datos :D

______________________________________________________________________________

Sevilla - Andalucía
Posts: 1276
Joined: Tue Dec 28, 2010 01:29 PM

Re: FWCONNECT con Mysql 8.017

Posted: Wed Dec 04, 2019 02:59 PM
xmanuel wrote:HDO también funciona en 32 y 64, además funciona con SQLite, Access, MS Server, DB2 etc, etc :-)


Saludos Manu, como estas?

Te he escrito varias veces a tu email pero no hay respuesta

FWH 25.12

Harbour/Hbmk2

Microsoft Visual C++

MySql 8.0

Antigravity

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: FWCONNECT con Mysql 8.017

Posted: Wed Dec 04, 2019 03:44 PM
ruben Dario wrote:Saludos
Regards
Hola La version de Mysql que tienes Instalada es de 32bits o 64bits.


Server 64bits.
But both 32-bit and 64-bit FWH applications can access the server using appropriate versions of libmysql.dll/lib or libmarialib.dll/lib

Are you experiencing any problems in connecting to Server version 8.0?
Regards



G. N. Rao.

Hyderabad, India
Posts: 1078
Joined: Thu Sep 27, 2007 03:47 PM

Re: FWCONNECT con Mysql 8.017

Posted: Thu Dec 05, 2019 12:18 AM

Saludos nageswaragunupudi

Tengo Mysql 8.0.17 de 64 bits
El problema que tengo es que no funciona Tdolhin ni Tmyslq ni eagle1 y FWCONNECT solamente me Funciona con ADO mi aplicacion es bajo 32 bits bajo windows 10 64 its.
Solamente funciona si Mysql es de 32 bits estas conexxiones Tdolhin ni Tmyslq ni eagle1 y FWCONNECT.
Lo que he visto que las ultimas versiones de Mysql son bajo 64 bits pero no veo de 32 bits. no se si estoy equivocado.

Gracias por su informacion.

Ruben Dario Gonzalez
Cali-Colombia
rubendariogd@hotmail.com - rubendariogd@gmail.com
Posts: 1276
Joined: Tue Dec 28, 2010 01:29 PM

Re: FWCONNECT con Mysql 8.017

Posted: Thu Dec 05, 2019 01:12 AM
ruben Dario wrote:Saludos
Tengo Mysql 8.0.17 de 64 bits
El problema que tengo es que no funciona Tdolhin ni Tmyslq ni eagle1 y FWCONNECT solamente me Funciona con ADO mi aplicacion es bajo 32 bits bajo windows 10 64 its.
Solamente funciona si Mysql es de 32 bits estas conexxiones Tdolhin ni Tmyslq ni eagle1 y FWCONNECT.
Lo que he visto que las ultimas versiones de Mysql son bajo 64 bits pero no veo de 32 bits. no se si estoy equivocado.

Gracias por su informacion.


Hola, yo tengo la version de 64 Bits pero alli no esta la lib de dolphin

FWH 25.12

Harbour/Hbmk2

Microsoft Visual C++

MySql 8.0

Antigravity

Posts: 1078
Joined: Thu Sep 27, 2007 03:47 PM

Re: FWCONNECT con Mysql 8.0.17

Posted: Thu Dec 05, 2019 12:45 PM

Hola las lib de 64 las descargue de la pagina http://www.sitasoft.net/tdolphinblog/
pero me parece que uno puede tomar el dll de la version de Mysql y converitrla a lib

La version de 64 Bits tu la compilaste, solo sirbe si FWH es bajo 64 bits

Tu sabes si las ultimas versiones de Mysql existe para 32 bits , porque todo lo veo para 64 bits

Saludos

Ruben Dario Gonzalez
Cali-Colombia
rubendariogd@hotmail.com - rubendariogd@gmail.com
Posts: 1276
Joined: Tue Dec 28, 2010 01:29 PM

Re: FWCONNECT con Mysql 8.0.17

Posted: Thu Dec 05, 2019 01:27 PM
ruben Dario wrote:Hola las lib de 64 las descargue de la pagina http://www.sitasoft.net/tdolphinblog/
pero me parece que uno puede tomar el dll de la version de Mysql y converitrla a lib

La version de 64 Bits tu la compilaste, solo sirbe si FWH es bajo 64 bits

Tu sabes si las ultimas versiones de Mysql existe para 32 bits , porque todo lo veo para 64 bits



Saludos


No he podido compilarla

Tu sabes hacerlo ?

FWH 25.12

Harbour/Hbmk2

Microsoft Visual C++

MySql 8.0

Antigravity

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: FWCONNECT con Mysql 8.0.17

Posted: Thu Dec 05, 2019 01:35 PM
FWH installation provides both 32-bit and 64-bit versions of libmysql.dll and libmariadb.dll, in the fwh\dll folder.

FWH also provides both 32-bit and 64-bit versions of libmysql.lib and libmariadb.lib for both bcc7 and msvc in the \fwh\lib folder.

For building a native 64-bit FWH application, you need to use 64-bit versions of the dlls and libs/dlls. For building 32-bit FWH application you need to use 32-bit versions of the libs/dlls/

FWH provides what all you need whether you want to build 32-bit or 64-bit application using either bcc or msvc and either xharbour or harbour.

With versions of MySql prior to 8.0, both libmysql.dll and libmariadb.dll work either with MySql server or MariaDB server.

All libraries like TMySql, Dolphin and FWH's internal library use libmysql.dll or libmariadb.dll.

If you can connect with one of them you can connect with other libraries also.

Now, what is the difference with MySQL 8.0 version?

When installing MySQL 8.0.?? you will see this screen "Authentication Method"



If you select the second option i.e.,
Use Legacy Authentication Method (Retain MySQL 5.x compatibility)
we can safely connect using our existing libmysql.dll and libmysql.lib whether we use TMySql or Dolphin or FWH's internal library.

We recommend using the second option and your present applications using dolphin, tmysql or fwh libraries will continue to work without any changes.

Note: From version 8.0 onwards, the libmariadb.dll will not be able to connect to mysql server even if we use Legacy Authentication method.

If you have already installed MySQL 8.0 server using the first option, you can now change by running "MySQL Installer" again and selecting "Reconfigure".

I personally recommend this. If you do this all your existing applications will continue to run as they are.

What if we select the first option?

Earlier versions of libmysql.dll do not connect. We need to use the latest clients released with this version.

When I installed I got libmysql.dll for 64-bits only but till now I could not download the 32-bit dll. Even with 64-bit dll, we are facing some issues of connectivity and we are yet to resolve these issues.

We, therefore, recommend reconfiguring the server to use Legacy Connectivity and continue to use your applications.

Note: Latest FWH libs provide some changes to use some of the latest features of MySql 8.0, which, of course, are not required for normal use.
Regards



G. N. Rao.

Hyderabad, India
Posts: 1078
Joined: Thu Sep 27, 2007 03:47 PM

Re: FWCONNECT con Mysql 8.0.17

Posted: Fri Dec 06, 2019 02:23 AM

Saludos nageswaragunupudi

Gracias, Me funciono eso era lo que necesitaba.
No he trabajo MariaDB voy hacer pruebas. Tienes algun comentario sobre este tema

Gracias por todo

Ok

Ruben Dario Gonzalez
Cali-Colombia
rubendariogd@hotmail.com - rubendariogd@gmail.com
Posts: 1078
Joined: Thu Sep 27, 2007 03:47 PM

Re: FWCONNECT con Mysql 8.0.17

Posted: Fri Dec 06, 2019 03:24 AM

Saludos

Compuin

Te refieres crear la LIb de Tdolphin

Ruben Dario Gonzalez
Cali-Colombia
rubendariogd@hotmail.com - rubendariogd@gmail.com
Posts: 1276
Joined: Tue Dec 28, 2010 01:29 PM

Re: FWCONNECT con Mysql 8.0.17

Posted: Fri Dec 06, 2019 04:26 PM
ruben Dario wrote:Saludos

Compuin

Te refieres crear la LIb de Tdolphin


Si

FWH 25.12

Harbour/Hbmk2

Microsoft Visual C++

MySql 8.0

Antigravity