Just to let anyone iterested that this problem was solve upgrading from RedHat 9
to Fedora Core 3 (MySql 4.1.7 on both systems), don't ask me why... :-) Frank ----- Original Message ----- From: To: dot...@lists.mysql.com Sent: Tuesday, November 23, 2004 6:18 PM Subject: DataAdapter Update and Connection

Hi, I'm working on a Windws Forms application under Windows which connects to a
MySQL serer on Linux 9.0. I tried filling datasets and executing commands and everything works, apart
from an invalid cast exception on date fields (driver version 1.0.2 only). My
problem is when I change values on a DataRow and launch DataAdapter.Update this
way:

//Here conn.State is Closed conn.Open(); DA.Update(); conn.Close();

The record on the database server gets updated, but I receive an exception (on
the Update line) saying that the connection is already open... If I remove the
conn.Open() line obviously it says that the connection must be valid and open.
It looks something goes wrong in the Update code... This happens with 1.0.0, 1.0.1 and 1.0.2 driver version. Thanks, Frank