Re: [Gambas-user] MySQL connection gone away, how to re-establish?

2013-09-06 Thread Benoît Minisini
Le 06/09/2013 16:01, Alexie a écrit : > Version 3.4.2 is used, and after reconnecting, the request will be retried > too? Currently i see an error thrown. > This is a mysql client option. When connecting to a mysql database, the Gambas mysql driver define the MYSQL_OPT_RECONNECT option, that tel

Re: [Gambas-user] MySQL connection gone away, how to re-establish?

2013-09-06 Thread Willy Raets
On Fri, 2013-09-06 at 16:11 +0200, Benoît Minisini wrote: > Le 06/09/2013 16:01, Alexie a écrit : > > Version 3.4.2 is used, and after reconnecting, the request will be retried > > too? Currently i see an error thrown. > > > > This is a mysql client option. > > When connecting to a mysql database

Re: [Gambas-user] MySQL connection gone away, how to re-establish?

2013-09-06 Thread Alexie
Version 3.4.2 is used, and after reconnecting, the request will be retried too? Currently i see an error thrown. 2013/9/6 Benoît Minisini > Le 06/09/2013 08:12, Alexie a écrit : > > Hi, > > > > We are connection to a MySQL database (on the local machine) and the > > application sometimes runs f

Re: [Gambas-user] MySQL connection gone away, how to re-establish?

2013-09-06 Thread Benoît Minisini
Le 06/09/2013 08:12, Alexie a écrit : > Hi, > > We are connection to a MySQL database (on the local machine) and the > application sometimes runs for days/weeks and numerous select, update, > delete, etc are going over the connection every hour (so it isn't lack of > traffic). > > We do things like

Re: [Gambas-user] MySQL connection gone away, how to re-establish?

2013-09-05 Thread Bruce
On Fri, 2013-09-06 at 08:12 +0200, Alexie wrote: > Hi, > > We are connection to a MySQL database (on the local machine) and the > application sometimes runs for days/weeks and numerous select, update, > delete, etc are going over the connection every hour (so it isn't lack of > traffic). > > We d

[Gambas-user] MySQL connection gone away, how to re-establish?

2013-09-05 Thread Alexie
Hi, We are connection to a MySQL database (on the local machine) and the application sometimes runs for days/weeks and numerous select, update, delete, etc are going over the connection every hour (so it isn't lack of traffic). We do things like: rResult = Main.hDB.Exec("UPDATE devices_alex SET

Re: [Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Jorge Carrión
Thanks Benoit. 2013/4/11 Benoît Minisini > Le 11/04/2013 23:48, Jorge Carrión a écrit : > > Well... I use my own class inherited from Connection to talk with > database. > > It's been workin without problems for 5 years. And don't undestand very > > well what it's happend here. (I attach the c

Re: [Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Jorge Carrión
Ricardo: Thanks for your answer. I have been using a own class inherited from connection that, until gambas3 migration of my applications, works fine with opens and closes of Mysql databases (I attach it here). The idea is forget all the thing and let the class do the work. I suspect that the fault

Re: [Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Benoît Minisini
Le 11/04/2013 23:48, Jorge Carrión a écrit : > Well... I use my own class inherited from Connection to talk with database. > It's been workin without problems for 5 years. And don't undestand very > well what it's happend here. (I attach the class with this mail). > I've been browsing the gambas so

Re: [Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Jorge Carrión
Well... I use my own class inherited from Connection to talk with database. It's been workin without problems for 5 years. And don't undestand very well what it's happend here. (I attach the class with this mail). I've been browsing the gambas source code in sourceforge and I've seen by myself the

Re: [Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Benoît Minisini
Le 11/04/2013 12:36, Jorge Carrión a écrit : > A few weeks ago I post a comment about a bug in gb-db-mysql (I guess) about > the loosing of language preferences after de time-out close connection of > mysql server. The solution aparently was to increase the time-out in the > server but, if the time

Re: [Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Ricardo Díaz Martín
Hi Jorge, I'm using gambas like mysql front end apss for a long long time too. I have never experimented this problem. My question is why do you need to keep open database connection for a long time? I only keep open connection for a while when I retrieve/save information from database. Maybe it's

[Gambas-user] Mysql connection loose country language preferences

2013-04-11 Thread Jorge Carrión
A few weeks ago I post a comment about a bug in gb-db-mysql (I guess) about the loosing of language preferences after de time-out close connection of mysql server. The solution aparently was to increase the time-out in the server but, if the time-out is too big, then my application hangs after a un

[Gambas-user] mysql connection

2011-05-20 Thread Keith Clark
I seem to have forgotten how to connect to a mysql database server. I can reference the document: http://gambasdoc.org/help/howto/database but I keep getting connection errors. maybe I don't have the address correct? What format does it take www.xxx.com? -

Re: [Gambas-user] Mysql connection bug/problem

2008-08-25 Thread Kamau Gatheru
ator on User-Admin with > (somehow) @% or @ip-address. > > Good luck > > > Werner > >> -- >> >> Message: 1 >> Date: Thu, 21 Aug 2008 12:50:28 +0200 >> From: Steven Lobbezoo <[EMAI

[Gambas-user] Mysql connection bug/problem

2008-08-22 Thread [EMAIL PROTECTED]
+0200 > From: Steven Lobbezoo <[EMAIL PROTECTED]> > Subject: Re: [Gambas-user] Mysql connection bug/problem ? > To: mailing list for gambas users > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=utf-8 > > Did you check the Mysql database in

Re: [Gambas-user] Mysql connection bug/problem ?

2008-08-21 Thread Steven Lobbezoo
Did you check the Mysql database in mysql ? In the users records there is also reference to the host the user is allow to use. If it's marked localhost, that's your problem. Regards, Steven Le jeudi 21 août 2008 à 13:39 +0300, Kamau Gatheru a écrit : > As a matter of fact I have, > > Here is a

Re: [Gambas-user] Mysql connection bug/problem ?

2008-08-21 Thread Kamau Gatheru
As a matter of fact I have, Here is a sample of the /etc/hosts, listing my database servers 127.0.0.1 localhost 127.0.1.1 MvServer 192.168.1.200 Mvserver 192.168.1.100 Server surprisingly even on the local machine (MvServer) only .host = "localhost" works On Thu, Aug 21,

Re: [Gambas-user] Mysql connection bug/problem ?

2008-08-21 Thread Marcelo Confortino
Kamau Gatheru escribió: > Hi all, > > I have been trying to connect to a remote mysql server (within my network) > and it seems all my local installations of Gambas cannot do that. Incidentally > I discovered that the .Port element doesn't work. I can run the following code > locally and it works f

[Gambas-user] Mysql connection bug/problem ?

2008-08-21 Thread Kamau Gatheru
Hi all, I am using Gambas 2.5 I have been trying to connect to a remote mysql server (within my network) and it seems all my local installations of Gambas cannot do that. Incidentally I discovered that the .Port element doesn't work. I can run the following code locally and it works fine. WITH Co

[Gambas-user] Mysql connection bug/problem ?

2008-08-21 Thread Kamau Gatheru
Hi all, I have been trying to connect to a remote mysql server (within my network) and it seems all my local installations of Gambas cannot do that. Incidentally I discovered that the .Port element doesn't work. I can run the following code locally and it works fine. WITH Conn .type = "mysql