Search found 12 matches
- Tue Mar 13, 2007 8:53 am
- Forum: Databases
- Topic: MySQL has gone away
- Replies: 1
- Views: 4151
I have made same tests and I have got the following results: -the error doesn't depend by the socket timeout; -the error doesn't depend by the server OS (I have tried with windows server 2003 and MacOS X); -the error doesn't depend by the client OS (I have tried with windows XP and MacOS X); -I get ...
- Thu Mar 08, 2007 6:48 pm
- Forum: Databases
- Topic: MySQL has gone away
- Replies: 1
- Views: 4151
MySQL has gone away
Do you know if there is a relationship between the socket timeout and the connection to a MySQL server with the revOpenDatabase function? When I stay connect from a remote machine to the server and I don't send a query for more than 5 minutes, I obtain the error "MySQL has gone away". PS I have tune...
- Wed Jan 24, 2007 6:04 pm
- Forum: Databases
- Topic: LOAD DATA LOCAL INFILE with MySQL
- Replies: 0
- Views: 3305
LOAD DATA LOCAL INFILE with MySQL
Hi, all I have to upload a file from a client Revolution application to a MySQL server, but I obtain the following error: "ERROR 1148: The used command is not allowed with this MySQL version" If I try with another client application (i.e. MySQL Query Browser) from the same machine it works. In mySQL...
- Wed May 31, 2006 7:59 am
- Forum: Databases
- Topic: Invalid connection ID
- Replies: 8
- Views: 11193
Thanks Jan, I found the error and I hope that it can help others. The problem is in the following code located in the openstack handler of the main stack: put the substacks of stack "Xdent" into lista repeat with i=1 to the num of lines of lista put line i of lista into finestra set the decorations ...
- Tue May 30, 2006 5:54 pm
- Forum: Databases
- Topic: Invalid connection ID
- Replies: 8
- Views: 11193
I have checked the external files and they are OK. As Jan suggested, I have verified the open connections before the query and I have discovered that I have no active connections. It is very strange because the same app worked same days ago and in IDE environment it works again now. I don't have any...
- Tue May 30, 2006 6:30 am
- Forum: Databases
- Topic: Invalid connection ID
- Replies: 8
- Views: 11193
- Mon May 29, 2006 6:57 pm
- Forum: Databases
- Topic: Invalid connection ID
- Replies: 8
- Views: 11193
Invalid connection ID
Hi, I am trying a query to MySQL database using MacOS X 10.4.6 and Rev 2.6.1. When I am in IDE environment all works fine, but when I make a standalone application I have the following error: -the connection is OK the revOpenDatabase returns a connection ID -the first query returns the error : revdb...
- Fri May 05, 2006 8:32 am
- Forum: Databases
- Topic: revOpendataBase on Linux
- Replies: 11
- Views: 13545
Hi Rishi, Thanks to you for your contribute too. Finally I solved my connection problem to MySQL DBNS with the help of Runtime Support. As Rishi suggested it was due to the dipendencies of dbmysql.so library used by revolution. Using ldd command you can discover what modules are not present in the s...
- Thu Apr 20, 2006 3:03 pm
- Forum: Databases
- Topic: revOpendataBase on Linux
- Replies: 11
- Views: 13545
- Sat Apr 15, 2006 7:48 pm
- Forum: Databases
- Topic: revOpendataBase on Linux
- Replies: 11
- Views: 13545
BvG, you are right, I have made a mistake in copy and past the command string. I beleave that the exact string for an user with no password is "", but I have made a lot of attempts and I have noted that the error depends only by the first parameter of the command. (it doesn'nt change if I use differ...
- Sat Apr 15, 2006 3:59 pm
- Forum: Databases
- Topic: revOpendataBase on Linux
- Replies: 11
- Views: 13545
Hi Jan Thanks for your reply. I had tried this command: revSetDatabaseDriverPath "/home/amministratore/Desktop/Revolution-2.6.1/components/global environment/database_drivers/Linux/" but the revOpenDatabase ("mysql","localhost","test","root",""") returns always the same result: revdberr, invalid dat...
- Sat Apr 15, 2006 10:26 am
- Forum: Databases
- Topic: revOpendataBase on Linux
- Replies: 11
- Views: 13545
revOpendataBase on Linux
When I try to connect to MySQL on a Linux machine, I have this result: revdberr.invalid database type. Where can be the problem? MySQL runs correctly and I can connect it with 'mysql query browser' application. WIth rev I can't. Is a drive problem?If yes, where have I get and install the MySQL drive...