>I am using MySQL ODBC Driver 3.51.11 to connect to a MySQL database running on Linux. I have a form with a data environment which have a cursoradapter connected to a table in the MySQL database via the MySQL ODBC DSN. There is no problem selecting records from a table, but when updating the records in the same table, there is an error stating that the table is not found, and i notice that the table name is in all lowercase while the physical table in MySQL is in mixed case. I understand that the table name of MySQL on Linux is case sensitive, I am wondering if the error is due to lettercasing or some other reason. Any advise is welcome!
>
David,
See
http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html
--sb--