Max_allowed_packet variable ??

2001-02-25 Thread Li Sze
uot;. Does max_allowed_packet means half of what is stated? Coz I tried setting the max_allowed_packet=2M, and eventually I can only insert 1M at any one time. I'm not sure whether I have to set any other variables as well. Please advise. Thanks, Li Sze

Win2K and MyODBC?

2001-02-15 Thread Li Sze
the mysql server with the correct username and password. I tested it using the mysql gui and it connects fine. Are there any known problems when using myODBC with Win2K? Or are there any write ups on what needs to be done to get myodbc to work in Win2K environment? Thanks, Li Sze

Help - SQLBindParameter not used for all parameters error

2001-02-08 Thread Li Sze
I have trouble writing a character into the database (the column is declared as char(2) not null) because I figured that if it appends a null at the end of the character data I want to insert (i.e.'A\0'), it would still fit. I bound the parameters first before assigning the data and executing

Re: Help - SQLBindParameter not used for all parameters error

2001-02-08 Thread Li Sze
arcross to my program but to no avail. I really have no idea what is going on here. Are there any other approaches that I may try out? Thanks, lisze At 17:05 08/02/2001 +0800, Li Sze wrote: Hi! If you only need room for 1 character you don't need a column with size 2. The last parameter

Fw: MyODBC Error

2001-02-02 Thread Li Sze
-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M As I have mentioned earlier, I couldn't even get 1MB through. Any idea anyone? Thanks, Li Sze - Original Message - From: Li Sze [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 4:35 PM Subject: Re

MyODBC Error

2001-02-01 Thread Li Sze
has gone away (2006) Regards, Li Sze