Hello,

Thank you very much for your reply. My problem is quiet different from the post you linked to me. The previous error seemed occurring whatever Kevin did (when committing a simple update). My app works fine until I don't do anything with it for a while (about 40 minutes). Contrary to Kevin I only use ODBC as I would use it with any Database Engine.

BUT...

When testing the session_timeout parameter I tried to decrease/increase its value and to time the exception triggering. It seemed matching. That's why I thought the parameter was the problem. But after some more tests (please read the protocol below) I have to conclude you are about true. The problem is probably not linked to a session timeout as the session ID before and after the crash are equal.

   I'm sure the light isn't so far :-) Thank you for your help.

Kind regards
Xavier.


Test Protocol :

- When I connect I get the parameters from the DOMAIN.CONNECTPARAMETERS. The timeout is set to 0 and the session ID is 288711 - I wait for the app to crash but thanks to delphi's exception the app doesn't terminate so...
- I get the session ID again and now it is : 288711





Dirk Lachowski a écrit :

Xavier CAMIER wrote:

MaxDB 7.6.00.12
Delphi 7.1
ODBC 7.06.00

Hello,

When I run my app but don't use it for a while I get a "[MySQL MaxDB][SQLOD32 DLL][MaxDB] Degree of derived table does not match column list; -1200 POS(21) Too few values" error message. I thought that setting the session_timeout parameter to 0 would solve the problem but it doesn't. I also thought that querying the database each minute would be a work around but it isn't.

Does anybody know how to keep and app idle without getting that kind of message and loosing the sessionid ?

Thanks a lot for your help
Kind regards
Xavier



Hi Xavier,

i don't think that this is a session timeout error. I've a long running
application on V 7.6 (running for some weeks now). I've also set the
session timeout to zero and it works fine for me.

Maybe this can help:
    http://lists.mysql.com/myodbc/8929

Cheers

Dirk


-----------------------
Lachowski Datensysteme GmbH
Strassburger Platz 25
D-30853 Langenhagen

Fon: +49 511 725353 71
Fax: +49 511 725353 89



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to