At 12:23 02/02/2001 +0800, Li Sze wrote:
Hi,
Try to use the variables below in your my.cnf file:
[mysqld]
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=1M
Set the values according with your necessities and read in the
MySQL Manual the item Tuning server parameters.
Regards,
Miguel
>Hi,
>
>I'm using SQLPutData and SQLParamData to insert data into the database. It
>works fine with data files smaller than 1MB. However, I get the following
>error for the last call to SQLParamData when the data file is more than 1MB.
>I have no idea what the following error means. I would really appreciate it
>if someone could tell me what went wrong or if I need to include more
>information about this problem. Thanks in advance.
>
>The following is the trace log from myodbc.
>----------------------------------------------------------------------------
>myMFC fff63add:fff7fe09 ENTER SQLPutData
> HSTMT 0x00891258
> PTR 0x01710004
> SDWORD 64974
>
>myMFC fff63add:fff7fe09 EXIT SQLPutData with return code 0
>(SQL_SUCCESS)
> HSTMT 0x00891258
> PTR 0x01710004
> SDWORD 64974
>
>myMFC fff63add:fff7fe09 ENTER SQLParamData
> HSTMT 0x00891258
> PTR * 0x0066eb78
>
>myMFC fff63add:fff7fe09 EXIT SQLParamData with return code -1
>(SQL_ERROR)
> HSTMT 0x00891258
> PTR * 0x0066eb78
>
> DIAG [HY000] [TCX][MyODBC]MySQL server has gone away (2006)
>----------------------------------------------------------------------------
>
>Regards,
>Li Sze
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
