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
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
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
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
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
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
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
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
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
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
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
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
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
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?
-
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
+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
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
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,
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
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
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
21 matches
Mail list logo