FOUND !!!!!!!!!
After many days to search the solution we found it ! The problem is solved
in the computer runnig microsoft jet 3.5.
You must change to 0 then values in the registry key
hkey_local\machine\software\microsoft\jet\3.5\engines\odbc; se the dword
ConnectionTimeout. The default is 600 in decimal as the second numbers. If
you put 0 the temporary table remain always active.
wonderful !
Massimo
----- Original Message -----
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
To: "Massimo Petrini" <[EMAIL PROTECTED]>
Cc: "MySQL list" <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 6:20 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
> Hi,
>
> 1) Try to reproduce the situation with pure myscl client (command-line
> client).
> 2) There is no any MySQL parameter that change life time of temporary
> tables.
> Only two parameter that defines life time for connection to mysql:
> - interactive_timeout The number of seconds the server waits for activity
> on an interactive connection before closing it. An interactive client is
> defined as a client that uses the CLIENT_INTERACTIVE option to
> mysql_real_connect(). See also wait_timeout.
>
> - wait_timeout The number of seconds the server waits for activity on a
not
> interactive connection before closing it. On thread startup
> SESSION.WAIT_TIMEOUT is initialized from GLOBAL.WAIT_TIMEOUT or
> GLOBAL.INTERACTIVE_TIMEOUT depending on the type of client (as defined by
> the CLIENT_INTERACTIVE connect option). See also interactive_timeout.
>
> But by default they are quite big: 28800 seconds.
>
> Mikhail.
>
> ----- Original Message -----
> From: "Massimo Petrini" <[EMAIL PROTECTED]>
> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> Sent: Friday, January 23, 2004 5:11 PM
> Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from
client
> running xp
>
>
> > 1) yes, I am sure because the problem is reproducible also with a sql ,
> > without to use the msaccess; if you use mysqlfront you can create the
> table,
> > insert data, view data. But if you move your point of view on another
> table
> > you lost the connection.
> > 2) to connect a temporary table in mysql from msaccess, it is necessary
to
> > create the table on server not temporary, connect the table from
msaccess,
> > drop the table on server; this is necessary only once; after use a sql
> > statement from msaccess, via sql pass through to create the temporary.
> Now
> > youn can insert data and use as a normal table. When you close the
> msaccess
> > session the temporary table is dropped immediately; otherwise if you
> leave
> > the session msaccess opened, but not in use, after some minutes the
table
> is
> > dropped. I think there is a variable to set in my.ini, but I don't
> > understand which is the correct name .
> >
> > So I don't understand.
> >
> > ----- Original Message -----
> > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> > To: "Massimo Petrini" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Thursday, January 22, 2004 2:16 PM
> > Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> >
> >
> > > 2 questions:
> > >
> > > 1. Are you sure that client or someone between client and MySQl server
> > > doesn't close connection?
> > > Because
> > > > the client have still the result of the query on the screen
> > >
> > > is not a proof that connection is still active.
> > >
> > > 2. How do you link your msaccess application with MySQL server?
> > > Are you sure that your application or someone between doesn't use
> > > connections pool?
> > >
> > > Mikhail.
> > >
> > > ----- Original Message -----
> > > From: "Massimo Petrini" <[EMAIL PROTECTED]>
> > > To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Thursday, January 22, 2004 1:35 PM
> > > Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> > >
> > >
> > > > We have a server running NT4 with mysql 4.017 (with the my.ini as
in
> > > > previuous mail). In the network the client (the single pc ) run
> msaccess
> > > > application linked to mysql database. In such case we use a
temporary
> > > table,
> > > > created as follow
> > > >
> > > > CREATE TEMPORARY TABLE wrk_AlzateIntervalli(Lotto CHAR(10) NOT
> > NULL,Indice
> > > > CHAR(3) NOT NULL,NMisura SMALLINT NOT NULL,IndiceIntv CHAR(1) NOT
> > > > NULL,ValMin REAL NULL,ValMax REAL NULL, PRIMARY KEY (Lotto, Indice,
> > > NMisura,
> > > > IndiceIntv));
> > > >
> > > > The statement sql is lunched from the client to the server; it
create
> a
> > > > temporary table used only from the client creator.
> > > > Is clear for you ?
> > > > Thanks
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> > > > To: "Massimo Petrini" <[EMAIL PROTECTED]>
> > > > Cc: <[EMAIL PROTECTED]>
> > > > Sent: Thursday, January 22, 2004 11:12 AM
> > > > Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> > > >
> > > >
> > > > > > no; because the client have still the result of the query on the
> > > screen
> > > > > and
> > > > > > on the server the thread is still existent in sleep mode.
> > > > >
> > > > > could you explain in details what is your system configuration?
> > > > > what is the client of MySQL server?
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Massimo Petrini" <[EMAIL PROTECTED]>
> > > > > To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> > > > > Cc: <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, January 22, 2004 11:08 AM
> > > > > Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> > > > >
> > > > >
> > > > > > no; because the client have still the result of the query on the
> > > screen
> > > > > and
> > > > > > on the server the thread is still existent in sleep mode.
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> > > > > > To: "Massimo Petrini" <[EMAIL PROTECTED]>;
> > > > > <[EMAIL PROTECTED]>
> > > > > > Sent: Thursday, January 22, 2004 10:05 AM
> > > > > > Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> > > > > >
> > > > > >
> > > > > > > Hi Massimo,
> > > > > > >
> > > > > > > May be after some minutes of inactivity client closes
connection
> > to
> > > > > MySQL
> > > > > > > server?
> > > > > > > In this case MySQL deletes all temp tables that were created
by
> > this
> > > > > > client.
> > > > > > >
> > > > > > > Best regards,
> > > > > > > Mikhail.
> > > > > > >
> > > > > > >
> > > > > > > ----- Original Message -----
> > > > > > > From: "Massimo Petrini" <[EMAIL PROTECTED]>
> > > > > > > To: <[EMAIL PROTECTED]>
> > > > > > > Sent: Thursday, January 22, 2004 7:30 AM
> > > > > > > Subject: temporary table in 4.0.17 on Windows W2000 and NT4
> > > > > > >
> > > > > > >
> > > > > > > > We have a problem to have "a long life" for the temporary
> table
> > on
> > > > > > innodb
> > > > > > > > mode. We create the table, but after some minutes of
> inactivity
> > > the
> > > > > > > sistem
> > > > > > > > drops the table. My.ini in as follow. Which is the parameter
> to
> > > > > correct
> > > > > > > the
> > > > > > > > problem ?
> > > > > > > > Tks
> > > > > > > >
> > > > > > > > Massimi
> > > > > > > > -----------------
> > > > > > > > # Example mysql config file.
> > > > > > > > # Copy this file to c:\my.cnf to set global options
> > > > > > > > #
> > > > > > > > # One can use all long options that the program supports.
> > > > > > > > # Run the program with --help to get a list of available
> options
> > > > > > > >
> > > > > > > > # This will be passed to all mysql clients
> > > > > > > > [client]
> > > > > > > > #password=my_password
> > > > > > > > port=3306
> > > > > > > > #socket=MySQL
> > > > > > > >
> > > > > > > > # Here is entries for some specific programs
> > > > > > > > # The following values assume you have at least 32M ram
> > > > > > > >
> > > > > > > > # The MySQL server
> > > > > > > > [mysqld]
> > > > > > > > port=3306
> > > > > > > > #socket=MySQL
> > > > > > > > skip-locking
> > > > > > > > set-variable=key_buffer=16K
> > > > > > > > set-variable=max_allowed_packet=16M
> > > > > > > > set-variable=thread_stack=64K
> > > > > > > > set-variable=table_cache=4
> > > > > > > > set-variable=sort_buffer=1024K
> > > > > > > > set-variable=net_buffer_length=2K
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > #PER REPLICA
> > > > > > > > server-id=19
> > > > > > > > master-host=pissarro
> > > > > > > > report-host=pissarro
> > > > > > > > master-user=root
> > > > > > > > #skip-slave-start
> > > > > > > > replicate-wild-ignore-table=OMTWRK.WRK_%
> > > > > > > > replicate-wild-ignore-table=omtwrk.wrk_%
> > > > > > > > set-variable=slave-net-timeout=172800
> > > > > > > >
> > > > > > > >
> > > > > > > > # Uncomment the following if you want to log updates
> > > > > > > > #log-bin
> > > > > > > >
> > > > > > > > # Uncomment the following rows if you move the MySQL
> > distribution
> > > to
> > > > > > > another
> > > > > > > > # location
> > > > > > > > basedir=C:\mysql\
> > > > > > > > #datadir=C:\AnnaNoBck\DATI\MySQL\data\
> > > > > > > > datadir=D:\applicaz\mysql\Data\
> > > > > > > >
> > > > > > > > #
> > > > > > > > log-error=d:\applicaz\mysql\data\mysql.err
> > > > > > > >
> > > > > > > > # Uncomment the following if you are NOT using BDB tables
> > > > > > > > skip-bdb
> > > > > > > >
> > > > > > > > # Uncomment the following if you are using Innobase tables
> > > > > > > > innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend
> > > > > > > >
> > > > > > > > #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB
> > > > > > > >
> > #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog
> > > > > > > > #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog
> > > > > > > >
> > > > > > > > innodb_data_home_dir=D:\applicaz\mysql\InnoDB
> > > > > > > > innodb_log_group_home_dir=D:\applicaz\mysql\InnoDB\InnoLog
> > > > > > > > innodb_log_arch_dir=D:\applicaz\mysql\InnoDB\InnoLog
> > > > > > > >
> > > > > > > > set-variable=innodb_mirrored_log_groups=1
> > > > > > > > set-variable=innodb_log_files_in_group=3
> > > > > > > > set-variable=innodb_log_file_size=5M
> > > > > > > > set-variable=innodb_log_buffer_size=8M
> > > > > > > > innodb_flush_log_at_trx_commit=1
> > > > > > > > innodb_log_archive=0
> > > > > > > > set-variable=innodb_buffer_pool_size=16M
> > > > > > > > set-variable=innodb_additional_mem_pool_size=10M
> > > > > > > > set-variable=innodb_file_io_threads=4
> > > > > > > > set-variable=innodb_lock_wait_timeout=50
> > > > > > > > default-table-type=innodb
> > > > > > > >
> > > > > > > > #solo >=4.0.14 permette di mantenere alla definizione di
> > > > > max_binlog_size
> > > > > > > la
> > > > > > > > dimensione del file di relay
> > > > > > > > #set-variable=max_relay_log_size=0
> > > > > > > >
> > > > > > > > [mysqldump]
> > > > > > > > quick
> > > > > > > > set-variable=max_allowed_packet=16M
> > > > > > > >
> > > > > > > > [mysql]
> > > > > > > > no-auto-rehash
> > > > > > > > # Remove the next comment character if you are not familiar
> with
> > > SQL
> > > > > > > > #safe-updates
> > > > > > > >
> > > > > > > > [isamchk]
> > > > > > > > set-variable=key_buffer=8M
> > > > > > > > set-variable=sort_buffer=8M
> > > > > > > >
> > > > > > > > [myisamchk]
> > > > > > > > set-variable=key_buffer=8M
> > > > > > > > set-variable=sort_buffer=8M
> > > > > > > >
> > > > > > > > [mysqlhotcopy]
> > > > > > > > interactive-timeout
> > > > > > > >
> > > > > > > > [WinMySQLAdmin]
> > > > > > > > Server=C:/mysql/bin/mysqld-max-nt.exe
> > > > > > > > QueryInterval=10
> > > > > > > >
> > > > > > > > ---------------------------------------------------------
> > > > > > > > Massimo Petrini
> > > > > > > > c/o Omt spa
> > > > > > > > Via Ferrero 67/a
> > > > > > > > 10090 Cascine Vica (TO)
> > > > > > > > Tel. +39 011 9505334
> > > > > > > > Fax +39 011 9575474
> > > > > > > > E-mail [EMAIL PROTECTED]
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > MySQL General Mailing List
> > > > > > > > For list archives: http://lists.mysql.com/mysql
> > > > > > > > To unsubscribe:
> > > > > > http://lists.mysql.com/[EMAIL PROTECTED]
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > MySQL General Mailing List
> > > > > > > For list archives: http://lists.mysql.com/mysql
> > > > > > > To unsubscribe:
> > > > > > http://lists.mysql.com/[EMAIL PROTECTED]
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > MySQL General Mailing List
> > > > > > For list archives: http://lists.mysql.com/mysql
> > > > > > To unsubscribe:
> > > > http://lists.mysql.com/[EMAIL PROTECTED]
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > MySQL General Mailing List
> > > > > For list archives: http://lists.mysql.com/mysql
> > > > > To unsubscribe:
> > > > http://lists.mysql.com/[EMAIL PROTECTED]
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > MySQL General Mailing List
> > > > For list archives: http://lists.mysql.com/mysql
> > > > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> > > >
> > > >
> > >
> > >
> >
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
