Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread noreply
> You do not understand the purpose of tsqlquery.datasource? I actually haven't done much GUI application programming in my life. I never used data aware components before in delphi, so it is all new to me. I always wanted to try them though. My brain understands procedural programming more, when

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread Martin Schreiber
On 12/11/2011 07:58 PM, nore...@z505.com wrote: >> Removing q1.datasource seems to fix the problem. >> >> Martin > > In lazarus it warns about recursive use of datasource. i never understood > exactly why this possibility exists... I can only think that sometimes one > component needs datasource t

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread noreply
> Removing q1.datasource seems to fix the problem. > > Martin In lazarus it warns about recursive use of datasource. i never understood exactly why this possibility exists... I can only think that sometimes one component needs datasource to be set, whereas other times the other one needs datasourc

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread wahono sri
Tested with libmysqlclient.so.18 (MySQL Libraries 5.5.16) to connect MariaDB server 5.1.55 is OK (Linux). -- Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training even

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread Martin Schreiber
On 12/11/2011 09:01 AM, nore...@z505.com wrote: >> Please check the server logs. It seems the server crashes while querying >> the index information. Please don't fix the problem now, I first want to >> fix the missing error message in MSEide. >> >> Martin >> > > How does it query the index inform

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread noreply
> Please check the server logs. It seems the server crashes while querying > the index information. Please don't fix the problem now, I first want to > fix the missing error message in MSEide. > > Martin > How does it query the index information.. is there a direct api call.. The logs I can chec

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-11 Thread Martin Schreiber
On 12/11/2011 08:56 AM, Martin Schreiber wrote: > Please check the server logs. It seems the server crashes while querying > the index information. Please don't fix the problem now, I first want to > fix the missing error message in MSEide. > There is a recursive master detail relationship in your

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread Martin Schreiber
On 12/11/2011 08:29 AM, nore...@z505.com wrote: >> I can connect now and can reproduce the problems. I'll check it. >> >> Martin > > Something is strange, lazarus has similar problems, but I was able to get > lazarus working at run time after trying for a while. At design time the > component give

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread noreply
> Suggestion: On Windows copy the correct libmysql.dll to the directory of > the MSEide exe and the directory of the test project to be sure that > Windows loads the wanted library. Did that before.. and I also put it into windows/system32. In lazarus I got it working temporarily but it is not co

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread noreply
> I can connect now and can reproduce the problems. I'll check it. > > Martin Something is strange, lazarus has similar problems, but I was able to get lazarus working at run time after trying for a while. At design time the component gives the "gone away" message.

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread Martin Schreiber
On 12/11/2011 12:32 AM, nore...@z505.com wrote: > > The project is here: > http://z505.com/download/mse/mysqlproj.zip > > I will have to add your IP address to the allowed remote SQL ip addresses > so you can connect to the mysql server I use. Otherwise access will be > denied. Can you email me y

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread Martin Schreiber
On 12/11/2011 12:32 AM, nore...@z505.com wrote: > > The project is here: > http://z505.com/download/mse/mysqlproj.zip > > I will have to add your IP address to the allowed remote SQL ip addresses > so you can connect to the mysql server I use. Otherwise access will be > denied. Can you email me y

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread noreply
After compiling a custom version of lazarus with the 5.1 mysql component installed, it also gives mysql gone away error, so it is not specific to mseide. In lazarus the query.Active stays true, whereas in mseide the active doesn't go to true, it keeps at false. ---

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread noreply
After compiling a custom version of lazarus with the 5.1 mysql component installed, it also gives mysql gone away error, so it is not specific to mseide. However in lazarus the query.Active stays true, whereas in mseide the active doesn't go to true, it keeps at false.

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread noreply
> On 12/09/2011 09:44 PM, nore...@z505.com wrote: >> What does it mean if a query component "Active" property stays stuck in >> false and won't go to true when you click it. When you try to put it to >> True there is no message stating anything sometimes. Does this mean an >> uncaught error like a

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread noreply
> BTW, I don't use prepare statement and I use MariaDB server, but I use > MySQL client to connect to MariaDB. > On my component form I am just dragging and dropping components... the sql I use is SELECT * FROM FOOBAR; I am not purposely using prepared statements but maybe the components choose

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread Martin Schreiber
On 12/10/2011 10:01 AM, wahono sri wrote: > Sometimes I get wrong message from git : > > Please, commit your changes or stash them before you can merge. > Aborting > > What is that? > You made modifications to the files. In MSEgit the changed files will be marked by red symbols, use RightCli

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread wahono sri
Sometimes I get wrong message from git : Please, commit your changes or stash them before you can merge. Aborting What is that? > libmysqlclient.so.18 if available. Wahono, please test your application > with libmysqlclient.so.18 on Linux. > If I have libmysqlclient.so.18 and libmysqlclient

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread Martin Schreiber
On 12/10/2011 09:08 AM, Martin Schreiber wrote: > On 12/10/2011 12:44 AM, nore...@z505.com wrote: >> How does mse database components figure out whether it is mysql 5.0 or 4.1 >> or 5.1 that it is connecting to, and how does it pick which dll? >> > On Linux it tries to load in this order: > 'libmys

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-10 Thread Martin Schreiber
On 12/10/2011 12:44 AM, nore...@z505.com wrote: > How does mse database components figure out whether it is mysql 5.0 or 4.1 > or 5.1 that it is connecting to, and how does it pick which dll? > On Linux it tries to load in this order: 'libmysqlclient.so.16', 'libmysqlclient.so.15','libmysqlclient.

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread Martin Schreiber
On 12/09/2011 10:03 PM, nore...@z505.com wrote: > When I press the test button in the query.sql it responds with test OK. So > it is connecting to the database and working from that way. The error > "gone away" has something to do with when the statement is preparedand/or > something to do with the

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread Martin Schreiber
On 12/09/2011 09:44 PM, nore...@z505.com wrote: > What does it mean if a query component "Active" property stays stuck in > false and won't go to true when you click it. When you try to put it to > True there is no message stating anything sometimes. Does this mean an > uncaught error like a connec

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread noreply
How does mse database components figure out whether it is mysql 5.0 or 4.1 or 5.1 that it is connecting to, and how does it pick which dll? I'm also thinking possibly my problem might be due to some dll problem, lazarus says that 6.0.0 dll is installed in my system. I didn't know there was a 6.0.0

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread noreply
When I press the test button in the query.sql it responds with test OK. So it is connecting to the database and working from that way. The error "gone away" has something to do with when the statement is preparedand/or something to do with the transaction. when you hit the test button in the SQL e

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread noreply
What does it mean if a query component "Active" property stays stuck in false and won't go to true when you click it. When you try to put it to True there is no message stating anything sometimes. Does this mean an uncaught error like a connection problem or some other problem that should be caught

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread noreply
> Please show the exact error message. > > Martin "Failed to prepare statement. MySQL server has gone away". This happens immediately when I set "active" to true via the query component. Normally, Gone Away means it has been a long time since you used the server. If gone away error occurs right

Re: [MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread Martin Schreiber
On 12/09/2011 07:49 PM, nore...@z505.com wrote: > When I put the database components on the form as recommended, and then > set the active property of the query to true, the mysql server > authenticates fine (no password problem) but then it says mysql server > gone away. > > when I try to set act

[MSEide-MSEgui-talk] MySql server gone away

2011-12-09 Thread noreply
When I put the database components on the form as recommended, and then set the active property of the query to true, the mysql server authenticates fine (no password problem) but then it says mysql server gone away. when I try to set active to true again, it just remains as "false" and won't swit