In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

MySQL error connect

Xailer professional forum in English
Responder
Cassiano de Oliveira
Mensajes: 475
Registrado: Mar Jul 24, 2012 10:21 pm

MySQL error connect

Mensaje por Cassiano de Oliveira »


Steps Performed:
4. I installed MySQL version 5 again
5. I opened the DBMS HeidiSQL
6. Test 01 connect to localhost database OK
7. Test 02 connect to remote database OK
8. I opened the Xailer
9. New Project
10. Sets the project to use mysql in the project properties and found
that MariaDB was cleared.
11. Added the component MySQLDataSource
12. I configured the properties utilized in the same DBMS above to
connect to the database
13. Test 01 - connect to localhost database OK
14. Test 02 - connect to remote database FAIL (the errors attached
pictures)
The following error appears (snapshot attached):
XMARIADBDATASOURCE:NEWERROR(197)
Erro XAILER/2058 Can't connect twice. Already connected: MySQL:Connect
Argumentos: ()
A LibMySQL.dll esta na pasta do projeto.
My Analysis:
1. I don't understand why the error that appears refers to MariaDB.
2. Name of Local Database and Remote ARE EQUAL
3. Password of the Local Database and Remote ARE EQUAL
4. User of the Local Database = root
5. User of the Remote Database = cassiano
6. In short the only difference is the user ...
But the same is true both that connects via other DBMS as HeidiSQL, Navicat,
Workbench
Could anyone help me?
Best Regards
Cassiano.
--

Attached files =?iso-8859-1?Q?Sem_t=EDtulo-1.jpg?= (51.1 KB)Â
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9443
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

MySQL error connect

Mensaje por ignacio »

Hola,
Compruebe este parámetro en su servidor (remoto):

Por otra parte. Le confirmo que el IDE utiliza realmente un conector de MariaDB tanto si se conecta con MySQL como si lo hace con MariaDB. De hecho, como comparten el mismo API es imposible que ambos APIs coexistan en el mismo ejecutable. Pero ello no supone absolutamente ningún problema.
Un saludo

Attached files
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Cassiano de Oliveira
Mensajes: 475
Registrado: Mar Jul 24, 2012 10:21 pm

MySQL error connect

Mensaje por Cassiano de Oliveira »

Hola,
Este parametro en mi servidor esta con 100.
Att.
Cassiano.
"Ignacio Ortiz de Zúñiga" wrote in message news:[email=52316ddb@svctag-j7w3v3j....]52316ddb@svctag-j7w3v3j....[/email]
Hola,
Compruebe este par탡metro en su servidor:
Un saludo
--
Ignacio Ortiz de ZíƒÂºíƒÂ±iga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
Cassiano de Oliveira
Mensajes: 475
Registrado: Mar Jul 24, 2012 10:21 pm

MySQL error connect

Mensaje por Cassiano de Oliveira »

Test this sample attached.
Un Saludo
"Cassiano de Oliveira" wrote in message news:[email=5231a461@svctag-j7w3v3j....]5231a461@svctag-j7w3v3j....[/email]
Hola,
Este parametro en mi servidor esta con 100.
Att.
Cassiano.
"Ignacio Ortiz de Zúñiga" wrote in message news:[email=52316ddb@svctag-j7w3v3j....]52316ddb@svctag-j7w3v3j....[/email]
Hola,
Compruebe este par탡metro en su servidor:
Un saludo
--
Ignacio Ortiz de ZíƒÂºíƒÂ±iga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
--

Attached files tstMysqlConnect.rar (2.6 KB)Â
Cassiano de Oliveira
Mensajes: 475
Registrado: Mar Jul 24, 2012 10:21 pm

MySQL error connect

Mensaje por Cassiano de Oliveira »

Any answers?
"Cassiano de Oliveira" wrote in message news:[email=5231aab0@svctag-j7w3v3j....]5231aab0@svctag-j7w3v3j....[/email]
Test this sample attached.
Un Saludo
"Cassiano de Oliveira" wrote in message news:[email=5231a461@svctag-j7w3v3j....]5231a461@svctag-j7w3v3j....[/email]
Hola,
Este parametro en mi servidor esta con 100.
Att.
Cassiano.
"Ignacio Ortiz de Zúñiga" wrote in message news:[email=52316ddb@svctag-j7w3v3j....]52316ddb@svctag-j7w3v3j....[/email]
Hola,
Compruebe este par탡metro en su servidor:
Un saludo
--
Ignacio Ortiz de ZíƒÂºíƒÂ±iga
[Equipo de Xailer/Xailer team]
http://www.xailer.com
http://www.xailer.info
Cassiano de Oliveira
Mensajes: 475
Registrado: Mar Jul 24, 2012 10:21 pm

MySQL error connect

Mensaje por Cassiano de Oliveira »

Ignacio, José, someone? Please test example q I sent in earlier versions of
Xailer works, the current does not work.
I'm waiting as soon as possible.
Sincerely,
Cassiano.
"Cassiano de Oliveira" wrote in message news:[email=5230ab52@svctag-j7w3v3j....]5230ab52@svctag-j7w3v3j....[/email]
Steps Performed:
4. I installed MySQL version 5 again
5. I opened the DBMS HeidiSQL
6. Test 01 connect to localhost database OK
7. Test 02 connect to remote database OK
8. I opened the Xailer
9. New Project
10. Sets the project to use mysql in the project properties and found
that MariaDB was cleared.
11. Added the component MySQLDataSource
12. I configured the properties utilized in the same DBMS above to
connect to the database
13. Test 01 - connect to localhost database OK
14. Test 02 - connect to remote database FAIL (the errors attached
pictures)
The following error appears (snapshot attached):
XMARIADBDATASOURCE:NEWERROR(197)
Erro XAILER/2058 Can't connect twice. Already connected: MySQL:Connect
Argumentos: ()
A LibMySQL.dll esta na pasta do projeto.
My Analysis:
1. I don't understand why the error that appears refers to MariaDB.
2. Name of Local Database and Remote ARE EQUAL
3. Password of the Local Database and Remote ARE EQUAL
4. User of the Local Database = root
5. User of the Remote Database = cassiano
6. In short the only difference is the user ...
But the same is true both that connects via other DBMS as HeidiSQL, Navicat,
Workbench
Could anyone help me?
Best Regards
Cassiano.
Avatar de Usuario
jfgimenez
Site Admin
Mensajes: 5718
Registrado: Lun Abr 06, 2015 8:48 pm
Contactar:

MySQL error connect

Mensaje por jfgimenez »

Cassiano,
I've already replied in the spanish forum.
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info
José F. Giménez
[Equipo de Xailer / Xailer team]
http://www.xailer.com
http://www.xailer.info
Responder