Page 1 of 1
Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Fri Aug 12, 2022 7:05 pm
by Compuin
Saludos foro,
Quien me puede decir como crear la cadena de conexion con ADO para MYSQL ?
Gracias de antemano
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Fri Aug 12, 2022 7:24 pm
by Baxajaun
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Fri Aug 12, 2022 7:29 pm
by Compuin
Muchas gracias
Mi otra duda es que conector mysql debo instalar para ADO?
Tengo mysql 5.7
Gracias
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Fri Aug 12, 2022 7:57 pm
by Baxajaun
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Fri Aug 12, 2022 8:02 pm
by Compuin
Gracias, ya lo descargue e instale.
Ahora debo configurar algo mas porque aun no me permite conexion
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Sat Aug 13, 2022 9:55 am
by Baxajaun
Hola,
si colocas por aquí el error o errores, se te podrá ayudar.
Muchas gracias.
Saludos,
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Thu Sep 01, 2022 7:58 am
by nageswaragunupudi
1. Download and install ODBC driver as advised above.
2. You need not worry about connection string. FWH functions will automatically and transparently do it for you.
- Code: Select all Expand view
oCn := FWOpenAdoConnection( { "MYSQL", <serveraddress>, <database>, <user>, <password> } )
if oCn == nil
? "Connect fail"
return nil
// success
// proceed with your work
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Sun Sep 04, 2022 2:55 pm
by horacio
Hola, Desde que versión está disponible FWOpenAdoConnection()?. Gracias
Saludos
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Sun Sep 04, 2022 5:38 pm
by nageswaragunupudi
Very old function
Prior to 1401
please check if you have fwh\source\function\adofuncs.prg
May I know what is your version?
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Thu Sep 08, 2022 4:58 pm
by horacio
Hola Rao, uso la versión 20.04 sin embargo en en el módulo adofuncs.prg figura de esta manera.
- Code: Select all Expand view
function Fw_OpenAdoConnection( cConnStr, lShowError )
Faltan parámetros de acuerdo con su ejemplo
Saludos
Re: Cadena conexion ADO / MYSQL
![Post Post](./styles/prosilver/imageset/icon_post_target.gif)
Posted:
Thu Sep 08, 2022 6:05 pm
by nageswaragunupudi
If you provide the 1st parameter as an array like this
- Code: Select all Expand view
{ "MYSQL", <serveraddress>, <database>, <user>, <password> }
the function will convert data from this array into a connection string and will use it to connect.